Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
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?
