-
Calculate number of days between two dates in the same column on the same sheet
Hello, Can a combination of the INDEX(COLLECT and NETDAYS Formula be used to get the number of days between two dates in the same column? I want to get the number of days between two dates on the same sheet, in the same column, that have matching names and different project types. For Example: Studio Name is equal to…
-
How to use previous cell value (from cell history) in a formula?
I have seen this question asked multiple times in the forum, but I couldn't find any clear answer provided in the answers. Please excuse me if a solution already exists, but if not, will someone please let me know if it is possible to use a previous cell value (from cell history) in a formula? I am specifically trying to…
-
Unable to edit smartsheet forms without constant reboot
Is anyone having trouble with smarthsheet over the past several days? Every time I go into a form to edit it, the cursor jumps fields after each character is typed. It is so frustrating. In some cases the cursor gets frozen in a field and jumps back and forth between two fields and freezes the whole system. I have yet to…
-
Sheet Countdown Timer
Happy Thursday. I know many have asked this question before, but does anyone know of a way to have a column actively countdown time? Even if a plugin is needed, it will be considered. Here is what I'm looking to do. When a form is filled out and a new line is added to the sheet, I'd like the "Countdown Timer" column to…
-
Send Forms via SMS
Would like to see a feature where we could send forms (or link to forms) via text messaging or SMS. Would like to send the form via SMS to the customer so they can fill out the form. Also, would like the clean looking PDF form created by the form submission to be auto sent back to the customer, instead of the Smartsheet…
-
Text to different Rows - Split by delimiter.
Hi, I have a cell@row value in the column Zone1 separated by a delimiter which needs to be split into different rows as a list of values similar to column Zone1new. Could i get help on this?
-
Merged: Freeze top row
This discussion has been merged.
-
Automatically copy one row when it is the end of the week or end of the month
Hello, I have created an automation to copy a row at the end of a week or at the end of a month so i can keep a log of all the calculated KPI's. This has been working for the past year. Unfortunately it stopped working a month ago for no specific reasons. Does anyone know what could be the reason? Thank you in advance for…
-
Merged: Dashboard Image Widget Opens In New Tab
This discussion has been merged.
-
Merged: Copy an automation from one sheet to another
This discussion has been merged.