-
Conditional alert and reminder
Hi I'm new in Smartsheet. I have a goal which is to set an automated alert like "If any change is made in specific column(s) by any editor after the date specified in Alert Date column, send an alert to the Admin." Is it possible to combine this many conditions? If it's not possible, how about setting a conditional…
-
Building Reports for Widgets
In a report, I want to change the column name "sheet name" to "Project" but when I double click on the column the rename option is not available.
-
Automated Call/Text Linked to Smartsheet
I'm wanting to link a Smartsheet/report to an automated calling/texting service like Call Multiplier or Dial My Calls. Similar to how a dentist or eye center may have an automated call when you're up for your appointment. In my case, I'm developing this to work with a project schedule to get a commitment from the…
-
If condition for Multiple Checkbox
Hi, I have a form with Multiple Checkbox and I would like to display Checkbox header if selected. If multiple checkbox selected , would like to display combination of those checkboxes selected. Pls help at the earliest. Thanks, Chetan.
-
sumif with children and checkboxes
I'm trying to create a setup where I sum together only the children if another box for that row is checked. I've come up with (see screenshot below as well): =SUMIF(CHILDREN(Include),1,CHILDREN()) But despite trying different variations of the formula I get everything back as #UNPARSEABLE I appreciate any help you can…
-
Alerts
How do I change a row color if project is past due
-
What to do when project ends?
Hi Smartsheet Community, Our company works with customers on projects for a set period of time. When a project is complete, we archive completed projects for internal use, but we no longer need our customers to view or edit sheets and sights in Smartsheet. When a project ends, is there is way to inactivate or close our…
-
if-then-else logical function
I have a symbol column valued ( green, yellow,red). I want to set the color based on a logical formula as follows: There is Start and a Finish date columns. if ((Start <= Finish - 8, "Green"), IF(AND(Start > Finish - 8 , Start <= Finish), "Yellow"), IF(Start > Finish, "Red") Anyone, can you correct this? Thanks Art
-
Indents
Hello. I am new to smartsheet and am trying to indent as follows: -parent level -child level 1 +1 +2 -child level 2 I cant seem to get it to allow me to indent the child level 2. (see the in process indent on the attached) It is making child level 2 an indent of child level 1 instead of an indent of the parent. Any ideas?…
-
ISNA transfer excel formula to smartsheet
I am trying to create a template in Smartsheet that was housed in excel. There is a bit of a complicated formula I am trying to transfer and having a heck of a time. Here is the excel formula: =IF(ISNA(MATCH(5,'Project Assessment'!G6:G22,0)),IF(ISNA(MATCH("High Risk",D8:D10,0)),IF(B11>935,IF(ISNA(MATCH(5,'Project…
