-
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…
-
Formula for SUM by the category
Unfortunately couldn't find the solution here. I'm just looking for a formula that will allow me to count total sum by the category of a product. Basically, I have two columns: first is the Dropdown list with the category of a product, and second one is the Text/number column with the bid amount. What I need is a total sum…
-
What’s new?
i get a lot of helpful information from the Community, Help and Blog sites. Is it possible to subscribe to a daily or weekly list of posts to these areas as part of my ongoing education about Smartsheet?
