Sign in to join the conversation:
Hi There-
I am typing in the formula per the attached screenshot correctly, however it is returning the sum of 0. Any ideas?
Thanks-
Jim
Try Countif. Sumif works if you are summing columns of numbers, what you are trying to do is count how many times teh 0001-Aparell Accessories appears.
=Countif(Pyramid:Pyramid, "0001 - Apparel Accessories")
For sumif, you also have to add the column to add up together.
Jim, I think you have to use the =countif function.
Thanks! It worked perfectly!
Glad I could be of help. I keep this post on tap for whenever I need it!
https://help.smartsheet.com/functions
I'd like to create an automation that does two things. Trigger: When rows are added or changed I want the following two items to happen. Record a date in the column "Completed". Set to today. Move row to sheet called "Completed Jobs" Please let me know if there is a way to do this using conditions?? If so, please give me…
a PM asked me to look at his schedule because one of his predecessor cells had #REF. We can't figure out why this is happening because he references line 176 in other cells in the column. When I went and looked at the schedule on my computer, the #REF error moved to a totally different cell and I don't see it in the same…
Hi, I am a new user and trying to work out why my pre start form I copied from another worksheet wont update the date etc in a new worksheet. I duplicated a sheet from one workspace to a different workspace. It is a sheet with a prestart checklist that in the original workspace, once its filled in it puts the days date and…
