-
Sum Network days but if field is blank results show invalid data type
The subject pretty well tells it all, I am trying to sum the network days between the request received and request sent date but if we haven't sent the request response as yet the field is empty and shows the error " Invalid data type" Current sum is =NETWORKDAYS([Quote Request Recieved]198, [Quote Sent Date]198) Can…
-
Weeks to go Formula
Apologies if this exists somewhere - I tried to look but couldn't find exactly what I needed. Using smartsheet to project manage for an event - I am wanting to have a 'Weeks to Go' Column that counts down how many weeks until the exact event date along each task item. Thanks!
-
Primary column
A new user is wanting me to verify that you cannot reassign the Primary column once your sheet it set up and saved. I'm pretty certain the answer is "no." Blessings, Loann
-
Feature Request
I have used Smartsheet for years and find it to be the best Project Management platform to date. I have a few features I'd like to suggest be added in the near future... please note if you'd find any of these helpful too. Hopefully this will help grab Smartsheet Developers/Engineers attention. - "View As (Other User)"…
-
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