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
Discussion List
-
If/Then formula helpIn Archived 2017 PostsI 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 …
-
Is there an "OR" condition in conditional formatting?In Archived 2017 PostsI'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 c…
-
Why did a simple search on text return partial matches?In Archived 2017 PostsIn 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 …
-
Collaboration between two client who both use SmartSheetIn Archived 2017 PostsLooking 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?In Archived 2017 PostsWhen 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"In Archived 2017 PostsI 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..............In Archived 2017 PostsThe 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. …
-
Counting the number of Red Symbols in Parent Rows OnlyIn Archived 2017 PostsI 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 weeksIn Archived 2017 PostsI 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 saturd…
-
Import from MS ProjectIn Archived 2017 PostsWhen you import from MS Project do dependencies import?