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
Due Date is Past Due - Checkbox
I'm trying to write a formula that will "check" the checkbox if the Adj End Date is Past Due and the % complete is not 100%) I started with just the Adj End Date portion and have not added the percent complete to the formula. This isn't working... =(IF(TODAY() > [Adj End Date]5,TRUE,FALSE) I then want to do conditional…
Comment title structure
Previously you could separate issues and information by a defined 'Comment Title' and then you can add comments under this section, but now the Title needs to come within the first comment and you then had replies. The problem is I am finding this change has unstructured my notes, as they cannot be clearly defined, making…
Suggestion for comments area
I have a settings suggestion. Mouse over comments would reveal the whole comment so i don't have to click on it to read it.. Make it a user preference. Thanx!
Notifications - Summary of changes in Email
Is there a way to send out a notification update that will either include the exported attachment of the sheet or just a list of the recent updates in the body of the notification email. I would like to send out an update to a large audience that do not have license or access to smartsheet, but I want to make it easy for…
FORMULAS (SUMIF?)
I have a task line 'Total Commission Percentage Earned to Rep'. As you can see, right now it says 10.03%. I need a formula that max's that percentage out at 10%. Sometimes the 10% will change to 8% ('Commission Percentage Allowed to Rep') and that will need to max out at 8% as well (the other 2% would go to 'Commission…
Need Help using the function WORKDAY
Hi there, I'm trying to use the function "WORKDAY" in order to have an end date output, based on a calculation, but when the "number_of_days" value is not a whole number, the formula returns an error. How do I have the formula always round up? Is it possible to mix the formula with the function "ROUND" with 0 digits? Thank…
Why no Parent() object in Formulas?
I would like to default a value in child row based on a column value in the parent row. Meta-Code: IF Parent()[Column Name]='valueX' THEN Child()[Column Name]='valueX' Can someone walk me through the syntax for that?
View/Comment Only?
I'd like to allow people to view my sheet and comment on tasks without being able to make any other edits. It would be great to have more specific control of user permissions to make this possible. Maybe somebody has a creative way to do this with sharing/publishing?
Grouping multiple columns
Hi, I have a budget sheet that hierarchically grouped by teritotry. There are columns that captures the category and subcategory. I am able to see the total amount of each teritory individually or the whole region using the hierarchy function. If I would like to see the total for the Category or subcategory, how do I go…
Appending Data from Excel
Is it possible to append data to the end of a Smartsheet? I have use cases where I would like to append data to the end of a Smartsheet from and Excel file but I can't seem to figure out a way to do it? My Excel sheets have exactly the same columns that the Smartsheet has and I just want to take the data from Excel and add…
