Sheets
Discussion List
-
Adding detailed information to a row / taskIn Using SmartsheetI have a column set up as "Notes" that I'm using to record all the details of that task. Eg., I'm running a software project so I need more info - it's a new feature, what are the features, what did the customer request, how do …
-
How to attach notes to a line itemIn Using SmartsheetHi, I need to attach notes to my line items. Setting a column as a Note Field is not practical, as I have too much informaiton than can fit on a short line. Using Comments is not practical, as I need to be able to easily access and edit…
-
Using Countif in place of Autonumber - formatting question!In Formulas and FunctionsI'm creating a ticketing system with multiple prefixes. Because of the multiple prefixes on one sheet, II opted to create a nested formula to number the tickets based on the various types of requests. Here is the formula: =VLOOKUP([Request…
-
Date/Time Stamp OptionIn Formulas and FunctionsWhile trying to figure something else out, I stumbled across a new option for having specific actions date/time stamped using the stem generated Modified (date) type column and the new Copy Row automation. . DISCLAIMER: This does not sc…
-
How can I use Salesforce to create a new Smartsheet from a Smartsheet template?In Apps, Integrations, and Add OnsWe want to use the Salesforce Connector to link data from individual smartsheets back to individual Salesforce records. However, we don't want to have to create a Smartsheet connector Workflow for each individual Smartsheet sheet, since we…
-
Formula to automatically link Week to DateIn Formulas and FunctionsHello, we have individual production schedule sheets where we assign hours against weeks. We want to create a column that will autofill with the Date it is starting based on the first Week Number column that has hours in it (example attach…
-
PMT calcIn Using SmartsheetIs there a similar function to PMT? =PMT(rate, period, pv, fv) etc? Have not been able to find one. Thank you.
-
Add Column to Row Report that was not in original sheetIn Using SmartsheetHi! I have created a Row Report containing information from just one sheet, with one "What?" criteria. I have the desire to add another column to this report, that does not come from the original sheet, just for notes purposes. T…
-
Including Half Day Holiday to Timeline Nonworking DayIn Using SmartsheetIs there a way to add half days as a holiday in a timeline (nonworking days)? EX: We are having a half day on Friday and Monday off for Memorial Day. I was hoping to find a way to include in this in the timeline (nonworking days)? https:/…
