-
How to auto-populate a dashboard when new sheets are added
I have created a workspace for my team where everyone has a sheet to enter projects and I have them all connected to a dashboard using reports and formulas. These sheets are just for small projects, but I am trying to figure out the most practical way for employees to enter their own projects and create their own sheets…
-
Help with IF, THEN
I want a calculation to run if a cell value is within a range. IF Cell X is between 1-4, THEN sum(cellZ, cellP, cellH) How do I write this?
-
Can you calculate time in Smartsheet?
I am setting up a new sheet for when employees return to the office with staggered start times and duration of their lunch breaks. Is there a formula that would calculate their end time depending on what time they started? i.e., I entered 7:15 and take a 45 minute lunch, automatically fill in 4:00 for my end time that day.…
-
Can we safely use cross-sheet references in column formula?
Hello everyone, I have a fairly large sheet (~5000 rows). I have one column whose value gets changed based on data from another column within the sheet. The source column is a country code column and the column that gets updated displays region based on the country code (EMEA, LATAM, NA, etc.). I decided to create another…
-
Copy References from one sheet to another, individual or bulk. + add multiple references
How do I copy an existing reference from one of my sheet to another existing sheet? How do I add multiple references without re opening the reference manager? It always closes.
-
QQ for else if formula is smartsheet
I am trying to get smartsheet to interpret my string value in # of days so I can use it in a formula. Any idea why I am getting an error with the following: =if([Complexity for contract changes]@row(Small - 6 months),"180",or([Complexity for contract changes]@row(Medium - 12 months),"360",or([Complexity for contract…
-
Sending a Form via A Trigger
Hello Smartsheets Community, I was wondering if there is a way to send a link to a Smartsheets form based on an email address that is entered into a sheet? For example, if I am in my sheet that I build the form from and I enter in a person's email address in the email address column, can that trigger sending a form to that…
-
Extract a number from text and multiply it to another column number
Hi A spreadsheet I am using that I have imported into Smartsheet has this formula: =IFERROR(W63*VALUE(RIGHT(X63, LEN(X63)-FIND("=", X63)))," ") I managed to get it to work using it like this in Smartsheet =IFERROR([System Details - PV Size (kWp) - QTY]@row * VALUE(RIGHT([System Details - PV Size- Model (kWp)]@row,…
-
Summarize a set of number values with text, but some values are blank
Hi all, I am creating a text summary that pulls numbers from other columns. It's for the results of a ballot, so I want it to look like this: 2 approve, 4 reject, 5 abstain And the formula looks like this: =([Vote count: Approve]@row + " approve, " + [Vote count: Reject]@row + " reject, " + [Vote count: Abstain]@row + "…
-
Help with IF... Again
I can't seem to get the hang of formula differences between SS and Excel. Here's what I need: I am trying to populate a status column based on a numerical value in another column. If the value is 197 or higher, I want a value of Yes returned. If lower, a value of No should be returned. Here is what has not worked for me:…