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. Archived 2017 Posts
Archives for March 2017
If/Then formula help
I have the following formula in a field to calculate a cost: =IF([Pre-ID]6, 5.18 * [Higher Qnty]6, 4.98 * [Higher Qnty]6) However, if the result of this calculation is not at least $300.00 I need the formula to insert $300 instead of what is actually calculated. How would I modify this formula? Is this possible? Thank you,…
Is there an "OR" condition in conditional formatting?
I'm a very new user (1 week) and I am trying to apply conditional formatting if any one of 4 conditions is met. I need an OR statement but can't figure out how to do it, other than to do a separate rule for each condition. I searched the community and help and couldn't find anything about OR conditions. Thanks!
Why did a simple search on text return partial matches?
In order to test the very basic search functions in SmartSheet, I added a unique text string to the Comments section in a few records in a few different ways -- with text before it, with text after it (a period), and alone. The search results don't make sense to me. It returned all of those three instances I created, but…
Collaboration between two client who both use SmartSheet
Looking for suggestions / best practices to make the most of SmartSheet with an important client who is ALSO a huge SmartSheet user. First step they requested is a simple file repository - will grow from there...
Why doesn't adding a comment to a sheet highlight the 'SAVE' button?
When I add a comment to a sheet, the "SAVE' button stays greyed out. This makes me think that comments won't be saved unless I do an additional action that enables the 'SAVE' button and then click the 'SAVE' button.
Clarification: Reports for "Current User"
I am using a report system where "Assigned To" is Current User. I am just seeking clarification for how this works/updates if multiple people have the report open simultaneously? Thanks!
New notifications great, but still missing..............
The option of when I "save as new" the new sheet doesn't copy over the notifications/reminders. As I roll about 20 sheets over each month, it is time consuming to set up all of the notifications/reminders. Please add. Thanks
Counting the number of Red Symbols in Parent Rows Only
I would like to count the number of REDs for Parent cells only (not children). Any help would be much appreciated.
Feature Request- row by row work weeks
I need to be able to assign different work periods to different line item tasks. We have some subs that work 8hr 5 day weeks and others that we accelerate for some work to do double shifts or 6 days a week. We also at times will add saturday to a sub for a period of time and then switch back to 5 day. Currently if I change…
Import from MS Project
When you import from MS Project do dependencies import?