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 2017 Posts
Archives for August 2017
Discussion List
Group Notification
Would like an update to the system. We would like to add a group (from our group management) to notifications. For instance, we have a work space that is shared to 23 people. It has 15 sheets so far in that work space. Its pretty time consuming to add each person on to the notification for when "something changes on the…
Smartsheet Jira connector not allowing sorting
I have created a workflow with applicable fields and would like to be able to sort on any column. The filtering feature works well but i need to also sort on various columns. The sort feature is grayed out on all sheets that are populated by Jira connector data.
RYGB balls based on due date & status
I am trying to have a RYGB call status say this: If Due Date is today or before today & status is NOT = "complete", show ball as RED If Due Date is tomorrow or 4 days from tomorrow & status = "Not Started", show ball as Red If Due Date is today or greater than today & status = "In Progress", show ball as Yellow If Status =…
IF Statement creating text result, not numeric value
Looking for guidance....I have an If statement which is creating a text value and not a numeric value, thus it won't allow me to choose those results and sum them up. Any suggestions? This is the If statement example I have which provides the end result number, but the value appears to be listed as text. Then when I run a…
Zap error 403 and 400 withe row update trigger - send row
Hi I getting trouble with my Zap. And so fare i cant figure out the problem. Is there a way you can help me to get this working again ? The Smartsheet have been the same all the time, but the problem suddenly startet urly last week. I reach put to yesterday av got this tip: Thanks for reaching out! Looks like your Filter…
Automatic Count Down
Does anyone know a formula that will automatically count down? I am currently using =DATE1-TODAY() The problem with this is that I have to open the sheet everyday to update the count down date. Thanks, Steph
Update existing smartsheet by excel
Hi, I have a smartsheet with 4 columns： building code, name, cs manager name and supervisor. I create this smartsheet by import excel. Excel has 4 same columns.. However, cs manager always change. We have 1000 buildings. Admin will send update list every week.. I know there is data live connector.. if I change info in…
Cash Flow Projection in Projects Sheets
Hi, I am using =IF(AND( ... )) to project in which month a disbursement will be made in a project planning sheet. Does anyone use an easier faster way of scheduling disbursements and depreciation? Regards
Last Modify Date based on Comments
I'm looking to see if there is a way to update the "Last Modified Date" system column when someone adds a comment to a row.
Sheet scrolling with mouse issue
Hi, I am unable to sheet scroll using my mouse. Pulling the side tag works but not with mouse since today. Any reason for this? Rgds Ian