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 September 2017
Discussion List
Organizational Hierarchy
Has anyone used SmartSheet to capture organizational hierarchy or some type of org chart?
Organize formulas on a sheet
Hi I have many formulas on a sheet which are linked to another sheet and the result is picked up on a dashboard. On the sheet i have added extra columns to place the labels but these column fields then show on the kanban card view which i don't want. So question is how best to organise formulas on a sheet, is the below…
Turn on update request replies email
I have a SmartSheet and I regularly send out update requests. When someone responds to the update request, I'm not getting the email notifying me of the update. How do I turn that on/insure that I get the emails? Thanks so much, Janet
Attempting a formula with multiple criteria
Hi, can anyone help with the formula for the following required outcomes? * $0 if the management agreement has not started [Mgnt Start Date], * Equal to the chargeable amount [chargeable amt] if the Management agreement has started ie [Mgnt Start Date] in the prior month * Equal to the previous month [Jan 17] if the…
Sumif Problem
I get a 'incorrect augment set' error with formula =SUMIF([Int/Ext]10:[BASE VALUE $]100, "Int", [BASE VALUE $]10:[BASE VALUE $]100) and have checked that the column 'Base Value $' is a text/Number format (having looked at previous comments). Any ideas what else to check
Modified Date by Cell not row
Hi, I have a use case where I need to apply current date when a specific cell is modified--not the entire row. I understand there is cell history, but need this cell modified date visible as a value in the sheet. Thoughts? Thanks, Sean
Finding the greatest value
I am working with two columns. For purposes here let's call them "Description" and "Total" I am trying to find the largest value in the Total column for rows 1 - 5 and then assign a different cell the value of the Description for that row. I can use the following IF(AND statement to compare 1st cell to the remaining other…
If NOT complete, change end date to TODAY()
Hi I'm trying to automatically increase the finish dates of tasks not completed, that were due for completion before today, to today. Is there any way to do that? Any help would be really useful
Formula to update status on a parent row based on any child row
Hi, Wondering if it is possible to create a formula to change the status of a parent row when a child status is updated. We have a number of Parent Status's and Child Status's ie If All Children are Unallocated then Parent is Unallocated If All Children are Allocated then Parent is Allocated But if any Child is In Progress…
Jira connector - Update sprint from smartsheet
Why can't I update the sprint of my Jira tasks created from smartsheets directly from smartsheet itself. Why cant I create new fix versions from my smartsheet itself