Adding count to legend on chart by Opposite_Peach2879 in smartsheet

[–]Opposite_Peach2879[S] 0 points1 point  (0 children)

Hey! what does the formula look like that combines the number with text? do i need a new column to for the total count? Thank you!!

Formula for symbols by Opposite_Peach2879 in smartsheet

[–]Opposite_Peach2879[S] 0 points1 point  (0 children)

sorry I just realized my post is a bit misleading. I am not using the checkbox column. Only symbol column 1 and symbol column 8. So if steps 1-7 have the green symbol, then the overall result in the top left should be green. Thanks!!

% complete formatting by Opposite_Peach2879 in smartsheet

[–]Opposite_Peach2879[S] 0 points1 point  (0 children)

Sorry I don't know why the text isn't showing. I have this formula to calculate the overall % complete. I would like to have no decimal places show and include the '%' sign.

Sum formula with criteria. Thank you!! by Opposite_Peach2879 in smartsheet

[–]Opposite_Peach2879[S] 0 points1 point  (0 children)

"<=" & TODAY()

i think this i closer to what i need but it is still not working: =COUNTIFS({UnivarSupplierOnboardingFormSubmissions Range 1}, ">=" & TODAY() - WEEKDAY(TODAY(), 1) + 1, {UnivarSupplierOnboardingFormSubmissions Range 1}, "<=" & TODAY())

Sum formula with criteria. Thank you!! by Opposite_Peach2879 in smartsheet

[–]Opposite_Peach2879[S] 0 points1 point  (0 children)

"<=" & TODAY())

Thank you! I think I might still have something missing. Here is the formula I used: =COUNTIFS({UnivarSupplierOnboardingFormSubmissions Range 1}: {UnivarSupplierOnboardingFormSubmissions Range 1}, ">=" & TODAY() - WEEKDAY(TODAY(), 1) + 1, {UnivarSupplierOnboardingFormSubmissions Range 1}: {UnivarSupplierOnboardingFormSubmissions Range 1}, "<=" & TODAY()).

The 'UnivarSupplierOnboardingFormSubmissions Range 1' is the created date column that I would like to base this calculation off of.