Hi I have a basic text entry sheet for a dashboard report. Fields are: [Subject], [Details], [Modified], [Due] In the [Due] Column I want to show that the month has changed so I can trigger an update …
Can you do A COUNTIF formula with less than 50 rows or does Smartsheet default to 50? If I delete the formula in the blank rows I get an "invalid reference" error message.
I am trying to create formula that subtracts to different dates in my data but instead of displaying the date of the result I want it to display "On Time" if less than or equal to zero and "Late" if g…
Hello, I am trying to measure against tasks based on whether they are completed, on hold, not started. I have a status column using visual symbol representation and am trying to determine the countif …
Hi, Looking to calculate the number of netdays since an event was recorded. I have a {Date of Incident} column and a {Classification} column Looking for the number of days since a specific classificat…
I know this is need of a combination of things, but I cant figure it out unless I use a range of cells. I would prefer to search the collective column to perform the task. I want to return the name of…
Hello All, There's a survey we ask people to fill out so we can better provide services. There are 32 specific locations and a long list of questions. I'd like to compile all of this information into …
I am trying to calculate a rolled up percentage of how many students have taken a test, scoring above 80% to those who have not taken the test at all. I have tried an AVG formula as a test for 5 taker…
Hi, I have a table which records driving infringements. What I want to be able to do is have a function determine if a driver has had more than one infringement in the last 12 months. Then use the Act…
Hi There I'm very new to smartsheet so for you this might be a very simple thing. I'll appreciate if someone let me know what'd be the formula if I want to raise a flag whenever the due date is 30 day…