Sheets
Discussion List
- I am not getting the result I need from a formula I am using. I am trying to track how many audits are completed and how many are left to do in total for this quarter '__ of ___ done', currently I am …
- Hi all! I am trying to collect an average over the last 12 rows (including the current row). To do this, I created 2 additional helper columns (Line-ID and Row#), and trying enclosing the condition in…
- Hi, I am trying to use this formula =IF([Next inspection due]@row <= TODAY(0), 1, 0) then mark it with a flag. in the Flag Due Date column. Every time I use this formula I get INVALID OPERATION becaus…
- When using a Report to pull data from a Sheet, the report allows you to configure the Gannt in various was (day/week/quarter, etc). When displaying the Report on the DB, and wanting to view a part of …
- For vaious methods of communication, Smartsheet has default pre-populated messages: SEND, SEND UPDATE REQUEST, and others. Is there a way for us to customize these pre-populated messages - highlighted…
- Hello all, I have created a Workflow to send a weekly email notification when rows are added or changed in a Sheet, but it doesn't work with "Run Now". It doesn't detect any of the changes made. I hav…
- I have been playing around with DDUpdate over the past few weeks. It has been working well until today, where all my mappings are now inactive. Fortunately, none of the mappings are in production shee…
- Hi, I have a sheet with formulas in multiple columns. Non-licensed staff are able to add rows of data via a form, and also make updates to existing rows of data via a dynamic view. They view the data …
- When Bridge queries a sheet, it will be indicated as such within the Activity Log. However, there is no transparency as to which API workflow this is coming from, so any kind of quick troubleshooting …
- Looking for a best practice to set up a scalable (target vs. actual, month-over-month) sheet - There are 15 specific varying metrics (e.g. numbers, $, %) collected monthly by different people. Each me…