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 2016 Posts
Archives for July 2016
Discussion List
Changing sign of a Sumif or Sumifs result
Is there a "proper" way to change the sign for SUMIF or SUMIFS formula results. I have found that =-SUMIF() doesn't work; but, that = 0 - SUMIF() does. Is there a way to do it without the "0"?
Report Widget SIGHTS - word wrap for Sheet Name Column
I am pulling in the column: Sheet Name through a report widget and the sheet name does not wrap. All other columns do appear to wrap. Is there something I can do to have the Sheet Name Column wrap? The Sheet Name should be FQHC Look Alike Work Group. Thank you
multiple signatures of unknown individuals on one document
I am creating a training tracking Smartsheet for our field employees. My challenge is coming up with a way to add signature lines (and text box) for all employees on-site for training to verify with signature that they have attended. I don't know beforehand who will be on-site for the training and the employees are union…
Comments on single cells or Column Titles
Is there a way to add a comment on a single cell? The discussion is for a line. I would like to add comments to column titles. I use that as a purpose statement for that column especially when collaborating with others.
IF statement with two criteria; not functioning
Hey all, Trying to get a “No” to appear if the checkboxes in each column haven’t been checked off by their due date. Currently, it says no regardless of the date and it only seems to switch to "Yes" if the Client Launched column is checked off. The two criteria are that the box is not checked off and the Launch Date is…
Maintenance Options
I have recently been engaged in transferring fairly large amounts f data from Excel into Pre-configured Smartsheets. The importation of the Excel Sheets into smartsheet worked well. The Move to another sheet worked well providing you did not try and move too many rows at a time. The pre-configured sheets were in a…
Customise Smartsheet notification content
The notification feature in smartsheets is great and is an efficient way to keep on top of any changes to my sheets; however, there are occasions when i would want notifications to go to other people but not for them to have to see the whole row (with some of my sheets the sheer number of columns makes this the rendering…
Recurring Update Requests by Contact
I have a sheet that serves as a team pipeline report and I would like to have a weekly update request where every row assigned to a specifc person is included automatically in the request. Each row has one designated person in charge and I would like for them to receive the notice to update each of their projects in the…
Average of RGY Children
Hello, I currently have a long long formula to look at the RGY balls of the children of a task and create a color based off of the sum of yellows vs. red vs. green and which one is greater than the other (see below). =IF(AND(COUNTIF(CHILDREN(), "") > COUNTIF(CHILDREN(), "Yellow"), COUNTIF(CHILDREN(), "") >…
Emailing row updates -- CC:
When mailing a row upate, would like to have a CC: option. Thanks, AEG