-
Update start date with report
Hi all a quick question from a relative newbie: I am setting up a project sheet and want to be able to issue report updates to our outside contractors on a project. I am struggling with a feature in smartsheet. I would like to have my engineering firm provide a start date on a task with a dependency without having to…
-
Alert User in Row if Date has Past Due and not Complete
I would like to send an alert to the person "assinged" to the appropriate row the day after a "Due Date" IF a "Status" column has/doesn't have a value(s). For example, "Send 'Assigned To' and email reminder 1 day after 'Due Date' IF 'Status' does not equal 'Completed; Canceled.'" I want to target these communications to…
-
Column Properties
Hi Community! Is it possible to only allow for a single type of text in column cells and not any other type? For example, if I choose the column property as a date, can the cell restirct the text in the cell to only allow for dates? This is done in Excel using data validation. Please help! Thanks, Dave
-
Trying to build a good, dynamic task list
I'm working on getting a good personal task list system going within Smartsheet. I've gone through a small number of efforts to get what I need, but I still have a problem around getting something dynamic and quick functioning. 1. Built a task list based on the task list template. With no automatic sorting, I have to sort…
-
Resource Availability
I need to figure out a way to view resource availability for a given time period, besides just visually scanning the resource view. Is there a way I can create a report that would tell me the dates that a given resource is not scheduled/assigned to a task across multiple sheets, so I can assess that resource (or group of…
-
Conditional Formatting a section
I have a balanced scoresheet. I'd like to have the header "Business Development" Status circle turn from red to yellow to green as the tasks below it are completed. For each task, I set the measurement as "completed" and it turns the Status cell green. Once 1/3 of the status cells are green, I'd like to change the header…
-
Moving rows and losing formulae links.
Hi there, I use smartsheet a lot to manage and track report issuing between multiple users. I regulary have problems when moving rows to enable organisation by priority and the cell links within the row change. I have to reapply the formulaes in certain cells which can be time consuming. has anyone else had this problem or…
-
If N/A checkbox is marked note % complete as 100%?
I have a "Not Applicable" and a "% Complete" column. I would like to create a formula that will automatically set the % complete to 100% if the Not Applicable checkbox is marked. Any suggestions? Thank you!
-
What formula to add to a "Days Remaining" field to pull from a date box
Hello, I am trying to create a formula for a column that will determine the number of days remaining from an expiration date. Furthermore, if possible, I would like a status indicator (green, yellow or red button) to remain statically green until the "Days Remaining" field gets down to 30 days remaining. At this point, I'm…
-
Dependencies by Assigned User
Can dependencies by automatically set by Assigned User? i.e. Fred has 5 tasks each will will take a day - can the start and end date be automatically set with dependancies?
