-
Current date against a ticked checkbox.
Hi, I'm trying to come up with a formula that will populate a given cell with the current date if and when a certain checkbox has been ticked. Please note, this date must be fixed, i. e. it must NOT change as the days go by. Is this possible at all? I know this is completely wrong, but just to illustrate better what I mean…
-
I want to set the name of a field to be the column name it is in. Is that possiblle?
I want to set the name of a field to be the column name it is in. Is that possiblle?
-
Move to Completed
Our team is using the Team Tasks by Priority template. Is there a way to automatically move completed tasks under the completed hierarchy?
-
Training Record
* Hi * I am wanting to create a sheet to keep track of our employee traing records. We have approximately 20 employees all with a number of training qualifications which they need to re-sit at diiferent intervals. I need to be able to list the employees with rows or columns for their qualifications where we can enter the…
-
Is there any way to use Check Box List?
-
Hi struggling a bit on the correct formula for overdue tasks
Hi, I need a function to look at If a column completed date is blank and the end date column date i s more than today to the return status "overdue" so I can report on overdue tasks ?
-
Dependencies, critical path and changing dates
Hi everyone, I have some issues with the dependencies function in Smartsheet and was wondering whether someone could help out. I am really keen to see the dependencies and the critical path, which are possible in SmartSheets. However, I found two issues... * 1. I would like to be able to see, that if I want to change a…
-
Formatting trouble
If you have created conditional formatting to color alternating rows a different colors, how do you format the document to automatically adjust colors when a new row is added?
-
Date Driven row roll off
We keep a list of Completed tasks. Based on the date in the Work_Ended column, I would like to autmomatically move rows > 90 days old onto another sheet, which we'll call Completed Archive. Is there any way to automate this process? Thank you!
-
Sheet with Database Normalization (Primary and Foreign Keys)
Can I upvote for Database Normalization? Many colleagues and I are using Smartsheet daily and are starting to implement it company-wide. One thing we'd like to do with it is use like a database. That said, it would be great if there's some capability of assigning primary and foreign keys.