-
How to Set My Weekly Update Request Form to Blank Cells before the Weekly Update Request?
Hello, I would like for this form to go completely blank on ALL cell-rows before the update request gets sent to the collaborators (not licensed users) every week. I already have the update request set to send every Friday at 9AM to request the form to be filled by the list of collaborators. I just want to make sure the…
-
Formulas Referencing Another Sheet
Hi, am working from a running sheet that currently has formulas but I'm trying to put the formulas into separate sheets so I can run metrics in a slightly different way and try to make the running sheet more efficient. However, whenever I type the exact same formula, with the only difference being referencing another sheet…
-
Project schedules with fix dates
Some of the tasks in my Smartsheet project have fixed dates that can't change dynamically ( ie, scheduled training sessions ). I'd still like to list them as dependencies for other tasks. I'm assuming there is no way to do this, based on other discussions about being unable to fix dates for tasks. I don't see how complex…
-
Automatic "Cell linking"
*What would be the best way to create a permanent link between cells. What I want is that if the user knows one of the bits of information, i.e. "WXP" that the other 3 cells get filled in automatically. We basically develop real estate and the project might start out known as the "Nome project" and gets assigned a Project…
-
Help with #DIVIDE BY ZERO error message
Hello, Hoping you might be able to assist me with a similar issue I'm experiencing. I've attempted to import a Trello board into Smartsheet for one of my colleagues and I'm getting the same error message, when I view it in grid view on some of the rows. The formula in question that is currently being used…
-
Teams Integration
Hi All, I have been tasked by my manager to incorporate SmartSheet into Teams. We have completed the integration and I can now see the shared sheets in Teams without issue. We would like to go a step further and be able to receive notifications in Teams when certain fields are completed on the Sheet. Is this possible?…
-
How to retrieve an error file
I made heavy traffic of cell links with other sheet and it was error on my sheet. I could not open the sheet. How to retrieve the file?
-
RYGGrey ball formulas for multiple columns (beginner)
I am trying to automate the RYGGrey ball status column, based on two date columns ([Start] and [Finish]) and 2 check columns ([Task Started] and [Task Completed]). Having trouble getting started and follow the right syntax. Here are my conditions I am trying to meet. TIA for your help. Grey * If TODAY < [Start] and [Task…
-
Sum up rows within the VLOOKUP formula
Hi everyone! I have several projects in my time tracking sheet and would like to use the VLOOKUP formula to save only the times per project in a monthly cost table. For that I used the following formula: =VLOOKUP([Project Number]12, {Sheet - Time Tracker (10-October) Range 1}, 8, false). Unfortunately, I only got one labor…
-
Nested IF Statement
I'm fairly new to Smartsheet and I'm trying to calculate a planned budget based on an "Assigned to" column. I'm getting unparseable, so I'm missing something. Here is what I'm trying to build if someone might help me solve the issue... =IF([Assigned To]@row = "Bob Dole", [Planned Hr]@row * 175), IF([Assigned To]@row = "Abe…