-
Sending an alert if any one of multiple columns changes after a deadline date
It doesn't appear that Smartsheet has an ISCHANGED function so I am struggling with an alert request. The request is for an alert if any one of 18 different columns has a value change after a deadline date. I guess I could create 18 Record Date automations on 7 different sheets to accomplish this, but that seems like a…
-
What type of formula should I use?
I need to add a specific start and end date dependent on which week # is selected in a "request update" form. For example, if "WK40" from the "WEEK #" column is chosen then "Start Date" would be 9/28/2025 and "End Date" would be 10/02/2025. The problem is that this is for a quarterly report, so there would be 14 weeks with…
-
My dashboard users are unable to view some of the charts, however I am able to view them correctly.
My users of the dashboard are getting the below error for some of the charts, however I am able to see them correctly. Please advise what is the solve for this error.
-
find manually entered duplicate lines
I have a sheet that contains practice-name, practice-seq,and coach-id. I have somehow added multiple exact duplicates. there are 8500 entries so its hard to find them….is there a report I can run to just show eact dups?
-
INDEX COLLECT MIN
Desired result is to pull the Initiative Name where the Days to Due Date is the least (so, due the soonest); then to make an index for the Top 10 Initiatives Due Soonest Currently using this formula: =INDEX(COLLECT({Project Master - Initiative}, {Project Master - Days to Due}, MIN({Project Master - Days to Due})), 1) This…
-
Count of Distinct Users in a Date Range
I am working on a metrics formula. It worked when I wrote it, I was using the data in a graph, which worked, I changed the graph type, and suddenly the data went to zero. Now, all o my formulas set up like this are all returning a value of 0. Trying to determine what went wrong. I am attempting to count the number of…
-
Parent/ Grandparent Cell Value
Hello- I am looking for a way to make every row return the same value as the highest level of its hierarchy (usually just children and grandchildren). I want it to report the top row in a column. In this example, I want all of these rows to return the value "Top Line" in a column.
-
Creating an Invoice
Good afternoon, I hope this makes sense. I know I have done this before in Excel but cannot remember how I did it. I am assuming it will involve some helper columns. I have a list of 100 people. These people can submit any number of timesheets for the month (though typically 0-4). They submit one timesheet per project for…
-
Return a value when one date is less than another
I'm trying to project the amount of non-bill hours we plan to spend on a project between the non-bill approval date and the contract end date. I'm getting an invalid operation error when using this formula: =IF([Column2]1 <= [Contract End Date]@row , [Approved Hours per week]@row , "") Here's my column setup: I've…
-
Average Collect Unparseable Error
I'm getting an Unparseable error with my average(collect) formula and can't figure out what's wrong with it. =average(Collect({Days to Approval}, {Level}, CONTAINS("Level 1", @cell ), {Date of Notification}, >=[Start Date]@row , {Date of Notification}, <=[End Date]@row )) All the references within "{}" brackets are columns…