-
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…
-
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…
-
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
-
Formula for Days overdue
I am using smartsheets to keep track of assigned items to my team. I want to insert a column that let's me know the days overdue. I don't know how to insert a forumla that does this. Can anyone help?
-
Problem with Gant Chart - Gear Icon not consistently shared
Hello All, The gear icon that I see in my gant chart schedule, is not showing up for certain people that I share the sheet with. This is a problem as our project managers need to be able to change the time line displays. Some people can see it, some people cant. I can not find the setting to always allow the gear icon to…
-
Can I use a button instead of a link?
Our training department uses a smartsheet embedded in the intranet for its training calendar. Click on a class and the description pops up with a link to the registration page. I'd love to replace that link with a SIGN UP or REGISTER button. Is that possible? (I'm brand new to Smartsheet, by the way.) Thanks! /shel
-
Formulas and Reports
Hello everyone This may be a simple fix; however, I am fairly new to Smartsheet and any insight would be appreciated. I built a report that is linked to three different sheets. They were originally imported from Excel that way the formulas would carry over easily. When I pulled everything together, the three rows that I…
-
Page break / separation between years / header
We have a pipeline report pulling data from a primary sheet that we need to separate out by year. Is there a way to add a row or page break to distinguish and separate the two years? Also, In regards to header row at top of reports is there a way to make the font larger and the width of the column itself larger in just the…
-
combining sheets
Hi, everyone! I would like to create a sheet or report that combines all of my other sheets so that I can look at them all together and sort by task. Ideally, this "master sheet" would update as each individual sheet is updated. Any help is appreciated!
-
automatic notifications when dates are passed
We created a new sheet for tracking our work and have a cell with a due date for design submittals. There is an empty cell next to the due date that we want the user to add either a check box or date to show the submittal was actually done. The question is, if the date or checkbox isn't filled out after the due date has…