-
How to Average(Collect()) while ignoring error messages
I would like to average the entire Value column whenever Customer is 'Y'. I've been able to successfully do if there are no formula errors by using the following: =AVG(COLLECT(Value:Value, Customer:Customer, true)) However, I discovered if there is an error in a value cell, the formula fails (it throws #NO MATCH error…
-
Help with returning Yes value if multiple criteria is met
I am trying to identify which RED customers from one Sheet 1 have already been added to our CEM (Customer Escalation Master) Sheet 2, so I don't have to manually spot check between both. I created a new Column called, "On Escalation Master?" and want to return a Yes or No value. I am getting #UNPARSEABLE error when I try…
-
SCC suddenly very slow on provisioning
What are reasons that may cause provisioning to slow to a crawl? previously the provisioning worked fairly well and would finish with a link to jump to dashboard. Now suddenly as of yesterday the provisioning is crawling and seems to stick at the "running Rollup/Summary" stage which then finally times out with an error…
-
URL instead of Display Text for SCC Project Dashboard?
When a project is provisioned in SCC it generates a dashboard link using whatever naming convention is setup in SCC. It doesnt appear to have any options in SCC to make it appear as a url instead? I also am checking the column properties or formulas for a way to make this a URL? The problem is that once a Dashboard Link is…
-
How to start time on a project and prompt for a list of tasks
Hello. Our Implementation Team is asking for a timer of sorts to capture their task time (whether onsite at clients or remote support). At the beginning of work on a specific day, the Implementation Tech would hit a start time button, then - they will work on their assigned tasks that are listed in our Smartsheet project…
-
Sum If Multi Drop Down Contains @Cell
I am struggling to get a formula to work correctly. I have a "Crew" Column which is a multi select contact column. I want the crew to be able to select multiple members and enter a single "Hours" for the day. For example Antonio and Tacho work the same job for 10 hours. Then to have each persons total hours for the project…
-
How to determine if a milestone is an extended milestone?
The formula value of [Duration]@row is a numeric value of 0 for both a Duration cell value of 0 and ~0. This means it is not possible to determine the number of work days that Smartsheet will then use for scheduling and % Complete calculations. Does anyone know if there is a way to determine which Duration cell value has…
-
What are the 'Order' options for RANKEQ and RANKAVG?
Hey, I could likely come up with this if I sat down and experimented with the formulas for a while, but I really feel like they should be listed somewhere and better documented and I'm really hoping someone else has already done the legwork. I don't even know if 'order' serves the same purpose in both formulas. RANKAVG…
-
I want to make a formula to work for all rows, details are below, Thanks!
This smartsheet has a parsing formula that we cannot convert as a formula column, I want this formula to be converted in a formula column, please guide, Thanks!
-
Combining IF and COUNTM?
Hello, all! I need to count items in a multiple option column, but only within a certain date range. If this were a single selection, I would use COUNTIFS, but this is different. Do you have advice on how to do this? I appreciate any guidance you can offer!