-
Auto Number Primary Column
Of the various data types a new column can use, it is logical that the Primary Column can only be Text/Number or Auto Number. However, Auto Number is not an option as of now. I would like to request having Auto Number be an option for the Primary Column. There are many applications of intake or request sheets are used…
-
Merged: Alternate row color banding that applies dynamically with filters and sorting
This discussion has been merged.
-
How to graph a range of dates when only given a start and finish
I have a sheet where I have individual tasks each with their own start and finish dates that can overlap. They each have a certain # of people assigned to the tasks per day. Essentially, it looks like start: 5/15/23 | end: 6/25/23 | #ofPPL/Day: 5 and for each day in between those dates there will be 5 people. The goal is…
-
Reapprove an Update
After submitting a form I trigger "Request an Approval" that has Approve or Decline. If I choose Decline I can trigger "Request an Update" - My question is how do I reapprove that update? I can trigger at a time of day, but I'm trying to trigger this approval by an action so I don't need to delay to process. Nothing I try…
-
How can I set paragraph line spacing in Document Builder?
I have a series of documents that I have mapped in Document Builder. I need to have the end result with a set line spacing to match the rest of the text from the PDF. I cannot find this setting. I know that I could hard code in the line breaks in the formula, but my issue is that the values in the formula are of variable…
-
Risk/Compliance Department Use Cases
I'm not quite sure if there's a better place to put this, however: My department (PMO) was the primary purchaser/user of Smartsheet, to track/manage our project portfolio and some other department processes/records. We have several members of our Risk and Compliance departments who are interested in the solution after…
-
Nested IF Function using Harvey Balls
Hi SS Community, I have the following nested IF column formula . The formula works properly through the "Red" part, but once I attempt to type DECLINED in the "Revised Final Date" column, the formula returns #invalidoperation. What can I change in my formula to show a Gray Harvey ball when I type DECLINED in the "Revised…
-
Dashboard Graphs with many columns/Bars
Is there a way to have a select all or a drop down menu in the legend to allow for just 1 item to be seen in the graphs. I know currently you can click individually on each one to turn them off however it can take quite a bit of time when there are 15+ datasets. I have been looking through all of the widget settings but…
-
Need help with an NETWORKDAYS formula to pause the day count when a Status is selected
I need help with a NETWORKDAYS formula that will count TODAY() if Escalation Completed Date is blank and pause day count if the Escalation Progress is "Phase 0: On-Hold" and the column for On-Hold Date has a date recorded (and will still count as TODAY() if blank). Current Formula I am trying after searching in the SS…
-
Merged: Processing Time and Cell/Row Limits
This discussion has been merged.
