-
Cell Behaviour for Cross Sheet Reference Formula with Daily Source Sheet Data Refresh via Data Shuttle
Hello, I have a metrics reporting sheet that relies on cross sheet reference formula to count rows from a formula column in a source sheet (let's call it Sheet A) that refreshes with data via data shuttle (set to 'Replace all target sheet rows with the data from the input file') once per day at 8 AM UTC (I am in PST). One…
-
Pre-Populate a Form with Query String
Hi, I tried looking at previous posts here to make this work, but I am definitely not doing it right. lol. I am trying to pre-populate 4 fields in a form. Here is the test sheet (public) https://app.smartsheet.com/b/publish?EQBCT=d8c8d8b25bf0477e963e7c07a8ca81bb Below are the form fields I am trying to populate. Any help…
-
Index, Match formula returning some, not all values
Formula was flowing correctly, but some change seems to have partially broken the pull but I can't figure out what/how. "Project" column dropdown is linked to a Master sheet. Budget Owner column contains the below formula which should look for the cell value in the Project/Cost Center/IO column within the P+CC+IO column of…
-
Automating date tracking and reminders
Hello, Im building a long-range fiscal quarter date tracking sheet with preloaded due dates over multiple years . I need reminders to notify the assigned person only when the item is active , still unsubmitted, and within 30 days of the due date. I also want to avoid excessive reminder frequency. Also i want to generate a…
-
Parent/child rows in a report even if not assigned to parent row
I need to build out a report that pulls the below information: Report needs to show the parent and child rows -Parent is not assigned but child is assigned -Parent is assigned and child is assigned I am open to helper columns but everything I have tired is not working. Formulas: -Parent Helper: =COUNT(ANCESTORS())…
-
Calculating Totals
Hi all, Im trying to use a formula to calculate how man hours of different leave type an employee uses to add to a report and or dashboard. Any suggestions on how to make that happen?
-
Reporting by month
Hello! I'm creating a reporting dashboard from a Smartsheet that tracks all incoming project types and I'm hoping to report a breakdown of the number of projects that are due each month. Is this possible with a particular formula? I'm coming up with a lot of errors. Thank you!
-
"WBS Helper Columns->" column
Does anybody know what the "WBS Helper Columns->" column does in the Project with Work Breakdown Schedule (WBS) template? Is it just a helper column where a function could reside, or does it have an "Off the Shelf" purpose?
-
"Helpful" Popups
There should be a way to hide tips and tricks from Smartsheet. If you have been working with formulas for years, you should be able to type in a formula without a pop up that blocks the other cells telling you how to use the =SUM() for example. It is always in the way of the cells I need to select. Should automatically…
-
Allow for Smartsheet to pull and return column names into a formula
Unlike some other spreadsheet programs, Smartsheet formulas cannot reference the actual header row (row 0) as data. I have a sheet which tracks many dates pertaining to our projects. Each column is named for the relevant milestone. I built a column formula that can iterate over those columns and pull the most recent date…