-
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.
-
Data shuttle - compare entries between source file and target sheet
I need to compare entries from the source file to entries in the target sheet (form in the target sheet creates these entries). If the entry is in the source file then I want to leave that entry in the target sheet BUT if the entry in not in the source file, I want this entry to disappear from the target sheet and need to…
-
Merged: "Send from" contacts in a cell or specific person enhancement
This discussion has been merged.
-
Form Options - Automation
Good morning, I'm trying to create a form in for entering and/or removing equipment from our site. There are times we have new equipment installed where equipment is not removed, and vice versa, but also times where both apply. Essentially, our wish is that the contractor would complete the form and if they check a box…
-
How can I get the sum of one column meeting two conditions
Trying to get multiple conditions and sum up total billable. Where Manager = John Smith in one column and Invoice Date = January in another column Getting the #UNPARSEABLE error =SUMIFS(AND(Manager:Manager, "John Smith", Invoice Date:Invoice Date, MONTH(@cell) = 1), [Billable Total]:[Billable Total])
