-
Help getting the summary of my sheet
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 using this formula: =COUNTIF(CHILDREN(Done2:Done130), 1) + " of " + COUNT(CHILDREN([Task Name]2:[Task Name]130)) + "" + "…
-
Moving data from one sheet to another - nothing works! VLOOKUP, INDEX MATCH, INDEX COLLECT
Hi Community! Hoping one of you might know what I'm doing wrong here. I'm trying to bring data from my source sheet (a list of requests) into a target sheet (list of placements). I've created a reference ID that exists in both sheets (KP Placement ID) that is an auto-generated number in the source sheet. It's manually…
-
Collecting Average Between 2 Ranges
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 an AND clause, however this seems to return unparseable. I think I am on the right path or way of thinking here, but that…
-
Is there a way around an Invalid Operation when using Dates generated by formulas
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 because the Next inspection due column is created from a formula of a formula of a date. Date6 is add on 6 months, Date1 is add on…
-
Add Column Description to Update Request
Include the column description when an update request goes out to provide some context to the column if it has a generic name.
-
Gantt View on a Dashboard - issues with Gantt showing data accurately.
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 the Data, and the Gantt at the same the ---> the Gantt isn't proper. Ou use-case is shipping goods measuring Pickup Date to…
-
Customization of Default Phrases in various areas
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 on the screenshot (and any other pre-populated verbiage)? So they are automatically pre-populated with our message?
-
Updating Status Based on RYGG symbols of Children Rows and RYGG Formula
New day, new formula conundrums! For these formulas, I'm looking to update the status of my PARENT rows (2 levels) based on the RYGG symbol as well as having the RYGG symbol is based the CHILDREN rows' Task Status column. I have both working but I feel like they could be cleaner and just wanted to get a second set of eyes…
-
Freeze Row
Enhancement request to add capability to freeze row (like freeze column)
-
Trigger "when rows are added or changed" doesn't work
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 have created this Workflow on other Workspaces and it works fine. If you have any idea, why in this case it is not working, do…