-
Access values stored in cell history
Hi guys, my idea here is to use the stored information in a cell value. Let's say that the first time this cell was changed is important to me and I want to store this value in a different column in my sheet. I would then use a formula to get this stored information, for example: =GETCELLHISTORY([info], [position]) info:…
-
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…
-
Converting Excel Formula
Hello, I am trying to build a formula that assesses several columns and returns results as a list. Kind Helpful Polite Cheerful Attentive Good Ok NeedsWork 5 4 3 2 1 Kind Helpful Polite Cheerful Attentive =TEXTJOIN(@, ",TRUE,IF(A@>4,"Kind",""),IF(B2>4,"Helpful"…..etc. works in Excel but I haven't been able to convert it to…
-
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?