1. Is it possible to assign the values of the number in each new line with a given step (or digit number) For example: 005 010 015 020 025 etc. 2. If I need to insert a new line between 010 and 015, I…
I have create a column to evaluate whether enough resources have been allocated to a task. It evaluates whether the percentage in the % Allocated column is equal to, greater than, or less than a secon…
Hi, I have a percentage complete cell which is working correctly when the following formula is used and the cell is set to show as a percentage: Formula: =SUM([Column5]24, [Column5]29, [Column5]33) / …
Hi, There I would like to know if It is possible to freeze a column one's validation is given to make sure no more modification can be done. Thank you,
I run a smartsheet for tracking coach/client engagements. There are typically 6 or more sessions in an engagement. Neither coaches nor clients can have access to the sheet. I need the coaches to repor…
Hi, Hit a lil road block here. Trying to automate the symbols for my status column based on drop down lists, but i keep getting a circular reference when putting in this formula, =IF([Lead Result]1="W…
Hi there, I am trying to set up an approval sheet. I would like my "Due Date Column" to auto fill a date 3 days before the date in my "Date" column only if my "Completed" check box is NOT completed. C…
H E L P! What is a simple way to formulate the "Evaluation" Chart in the Screen Shots attached, based off ONLY the children rows of the 4 Departments on the top of the sheet in both the "status" and "…
Hi, I have a sheet that I use for accounts. I have a column for Invoice Date, a column for Due Date and a column for Status. I would like a formula for the status column to read "due in X days" ( a co…
