-
Quarter Formula
I am trying to create a formula that extrapolates the quarter (Q1, Q2, etc) based upon the end date column. Has anyone done this before? Thanks in advance for any help provided.
-
Creating a unique ID based on two other columns
I'm trying to create a unique id based on values in 2 columns: partner and label. In our data, we have names associated with partners, but when we share data we don't want to share names, so instead I'd like to create IDs. As you can see in the sample below, we use two columns because names can be repeated between…
-
Time spent in a particular status (Count of days)
I've been racking my brain and maybe thinking too deep on it but can't figure out a way yet. Ok so let's say you have 3 status's Open In Progress Closed You want to have a counter that shows how many days it's in that particular status. I thought about the column that shows last updated but there are other columns of…
-
Autofill a static date using automation
I am using a formula to compare the date created and the date due to return a green check, if not then a red 'X', but the date due column has to be a date. The automation workflow to record the date due if a specific value in a dropdown list is selected only allows to record the current date and if I want to force a…
-
SUM formula with extending range
Is it possibly to have a SUM formula in a cell at the top of a column, calculating the sum of the contents of that said column, with the range beginning at a specific row but continuing to the bottom of the sheet and extending down as rows are added to the sheet automatically? It would obviously be easier for me to just…
-
Count IF Range Match to Column Header
Hi, I have a master sheet with 150 columns with unique names. In these columns are check boxes. Depending on the row this box can be checked or empty. I'd like to write a CountIFS function that allows the range to be selected that matches the specified column name. I don't want to manually select that column for the…
-
How to divide single request with multiple contacts to individual requests.
Does anyone know how to take a single line, with a single multi-select cell, and have that line parse/delineate/divide in to individual lines, either through a formula or an automation? Scenario: we are receiving schedule block request for team, and multiple people may be on the block request, therefore we have multiple…
-
IF THEN statement
I created a column "Past Due" and I want to plug a formula in it to determine if a subtask is past due with a "Yes" or a "No". My IF/THEN statement produces an "Invalid Data Type". Here is the statement: =IF(AND(Finish:Finish, <TODAY(), Status:Status, <>"Complete", Health:Health, <>""), "Yes", "No") Finish is a date. I…
-
Using two index/match formulas to sync data from 2 sheets to a master
I'm trying to pull data from two different sheets into a master sheet using two index/match formula's within an iferror however it is only partially working with some pulling through correctly and others coming up as no match even though there is a match. In the example below KYP-RSK-002 should bring a review status of Due…
-
Needing Two Timestamps in One Smartsheet
Hello, Can someone please assist with having two timestamps? I need to have our "Timestamp" in the first column when the customer submits a quote request, and another timestamp in "Arista Timestamp" (with date and time) of when "Quote Request Sent To WWT?" changes to "Yes". Right now my workaround is to have it record a…