-
Trigger Report Due when month changes from modified date
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 request. How would I go about doing this? Regards Steve
-
Count If less than 50 rows
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.
-
Formula Help
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 greater than 0. I got the formula to display correctly but it is auto displaying in my columns where no data is entered.
-
COUNTIF formula for visual symbol
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 formula to accomplish this so that I can measure against and build out the widget in a dashboard view. Any help is greatly…
-
Number of NetDays since last event
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 classification was reported i.e. {Classification}, ="Lost Time Injury". Want to be able to report this as a Key Indicator of No. Days…
-
Max value with min collect
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 the Visit Provider who has the greatest number of SumCompSched for each Phase & Clinic. I appreciate the help in advance.
-
Compiling Survey Results
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 a metrics sheet, and in the end create a dashboard. By some miracle was able to tally how many times the specific location…
-
Formula percentage with additional formula for roll up percentages
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 takers, but the % is incorrect. Here is the formula I have used: =AVG([TEST 1: Establish Point to Point Connection]3:[TEST 1:…
-
How to add a Red Flag when there is an entry more than once in last 12 months
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 Actions and Alerts to notify their manager. But need the function to work first before I can do that. I know how to use the…
-
Raise flag if due date is within 30 days
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 days from the current date. We'll appreciate your help. Thanks Raashid K
