-
Row Copy Automation
I have two sheets - a Checkpoint sheet and a project RAID log. If Action Required is set to YES on the checkpoint sheet, the copy row automation should trigger to copy the row from the checkpoint sheet to the project RAID log. I have hidden columns in both sheets so that they match but only the relevant columns are shown…
-
If 100% complete, mark another column Done
This works on another sheet, so not sure what I'm missing. I have two columns : Status and Complete%. If a row in Complete % is entered as 100%, I want Status to show as Done. Here's the formula I've tried to put in the Status column, which outputs #UNPASEABLE =IF([% complete]@row = 100%, "Done")
-
How do I return a value from a chart on another sheet using multiple values?
I have a Data Chart for wiring harnesses based on Year, Make, and Model of commercial Vehicle (it's quite extensive) I have another chart that has incoming orders, where I am given the year, make, and model of the vehicle I need to return the harness from the Data Chart formulaically. In excel, I am able to do this with…
-
Contains any text
I am trying to write a formula that asks if a cell has any text (at all, not specific text), then I want to reduce another cell by 1000 if true, blank if false. This can also be achieved if it is not blank? I have written a formula that provides a month that we have to employ a new staff member to service the growth from…
-
Modified (date) and filters
My team is maintaining a sheet consisting of row entries for tracking activities. Multiple collaborators are providing updates. I have a column with their name so they can easily filter which rows belong to them from a pull down. I also have a column with a Modified(date) field. I do some calculations to show when a row…
-
COUNTIFS with OR
Hello! Could I please get some help with this COUNTIFS? The intention is to count the rows where 1-Ref is either Complete or Attestation. I tried the below but it's currently returning UNPARSABLE. =COUNTIFS([1-Ref]:[1-Ref], OR(([1-Ref]:[1-Ref] = "Completed", ([1-Ref]:[1-Ref] = "Attestation")) Thank you!
-
Dynamic numbering of feature list
I have a feature list that has a number associated with each of them (by row). I'd like to be able to reorder the list as I get input on their priority and have the number associated with it dynamically update. For example, if #5 moves ahead of #3, I'd like #5 to be #3 and the others below to reorder too.
-
How to pull data from most recently created column?
I have data that I upload manually every month, and would like to reference it into another sheet; however I only want the last column created to be referenced and I want it to happen automatically without having to change the formula to reference a new column So in the dashboard it'd hold this info.. person x || most…
-
Expected percent complete of a task
I am trying to calculate very simply the expected percent completion of a task using the below formula and it is coming back unparseable =([Today]@row - [Realization Start Date]@row)/ [Realization End Date]@row-[Realization Start Date]@row)
-
Adding Vimeo Showcase to an existing Dashboard (via the web content widget)...
I can add a Vimeo video successfully to an existing Smartsheet dashboard, however for some reason I cannot link a Vimeo Showcase in the same way? I get the following error message Invalid URL or embed code. URLs without https are also prevented. Select the link above to see what content is supported (which takes me here…
