-
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!
-
Nest IF formula
I have tried looking at the help but it doesn't provide details on creating nested IF formula. I am trying to say: If the column has name 1, then return statement A; if the column has name 2 then return statement B, if neither then return statement C. Any tips?
-
Referenceone sheet and if 0, reference another sheet
Hello, I've been using smartsheets for several years now but really only starting to use formulas until recently so forgive my lack of knowledge. I have three sheets in play here. The primary sheet is looking at the second sheet for an average based on all references of a SKU. The second sheet might not have data for a…