-
I need help to sum all data by month & owner in one column for a pivot table for our dashboard.
This is our raw data sheet. For the pivot table chart I need to sum the location total for each owner. by month into one single column in my pivot table sheet. The pivot table sheet will then display on our dashboard. And the pivot table is not an option for us right this moment. Here is our pivot table chart so you have a…
-
Import a formula via workflow
I was playing around with the workflow and almost got a formula imported However after the formula got added it leaves a ' mark before the formula , that must be manually be removed for it to actually take effect Kind Regards Brandon Austin
-
Retrieving Ancestor (date) value from multi-level parent-child rows
Hi All, I used the following formula to retrieve ancestor (first parent) date value of the multi-level parent-child rows for each row. =LEFT(INDEX(JOIN(ANCESTORS(Date@row), ","), 1), 8) The issue that I'm facing is the return value being "TEXT" despite having "DATE" column type. Since I have to use this return value in…
-
Support - Formula that calculates difference between times in a quarterly increments
Hi Smartsheet Community, I'm attempting to figure out a simple formula that would calculate the difference between 0800 and 0830 in quarterly increments. At this current time i'm unable to figure out how to create a successful formula that would show the correct -0.50 for the following. Should 0825 and 0900 be entered, the…
-
Use IF THEN Formula
IDK what I'm doing wrong as it Allllmost works. Trying to create a formula to say, If you look at this overall score... if it's 0 - 54 = Tier 3 If it's 55 - 90 = Tier 2 If it's 91 and beyond = Tier 3 I'm using this formula... it works except it won't display tier 3... =IF(Answer21 < 55, "Tier 3", IF(Answer21 > 54, "Tier…
-
Index Match question
Hello, I have 2 sheets, 1 is a tracking sheet, the other is a reference sheet. I need to pull into the tracking sheet a dollar amount from the reference sheet. The dollar amount is based on the information pulled from 2 different columns - Job Title and # of hours. I tried to use a join function to simplify the index…
-
Dashboard with Set Time Frame Options
NOTE: I am a Smartsheet novice. I need to set a formula I can use for setting up a dashboard that counts specifics within set date ranges and enables users to see data sets within specific time frames. For example, 14 days ahead, 30 days behind. Can please someone assist?
-
Can you Change the End Date when Status Changes?
Is there a way to change the End Date to today, when a status is changed to either Completed or RYG is Green?
-
Multiple IFs around Dates
I am trying to create a column formula that says if [Date of Record]@row is less than a specific date (7/14/23) for instance, then return the number 43. If it is between 7/14/23 and 8/22/23 then 46, and so on. Is this possible?
-
Highlight duplicate entries
Hello, We are using Smartsheet to track payables and would like some sort of conditional formatting or formula to alert us if an invoice number is a duplicate on the same sheet. Is there a way to do this? Similarly, could we use a formula to look to other sheets as well? Or are formulas self contained within each sheet?…