-
Creating horizontal view for existing sheet
Hi, I'm trying to get sheet A (vertical view) into sheet B view (horizontal view). Sheet A: Sheet B: the helper column date is in txt/number so it would match sheet A. Could anyone help? Thanks. :)
-
Pulling next date from a sheet
Hello! I am looking for assistance with a formula that can pull in the next action date from one sheet to another. For context, we use sheets for customer renewal project plans. We also have a tracker that gives an overview of all the project plans and their name, completion, next action date, status, etc. What I would…
-
Workflows: copying values from one cell to another within the same sheet
Hello! I have a quick question regarding copying and inputting data. I am aware that rows can be moved or copied into other sheets via workflows. However, is it possible to create a workflow automation that copies/replicates data in "Cell A" into "Cell B"? The column properties of all the cells are set to Text/Number. I…
-
Count distinct values within cell
a
-
Automation Error
Not sure if this is the right place for an automation error or not. I have previously asked about returning a value once (not sure if my link would work for everyone or not). I was able to get it to work with a metrics sheet, a helper column, and a copy rows automation. However, the ID I used for that one, is only valid…
-
=SUMIF for calculating budget on multiple rows.
Hi! I have a sheet that breaks down different accounts. Some line items within an account will have a cost associated with it. I want to be able to calculate the cost of those line items per account. If I do a simple =SUM formula, it gets confused as things are added, changed, filtered etc. I tried to write a =SUMIF and it…
-
Combining IF functions to read multiple columns and create a flag
Hi all, I am working with the attached sheet trying to create a few flags to appear when certain information is present. The 3 flag columns are '2 Weeks - No Data', '2 Weeks - No Check Ins', '2 Weeks - No Paired Check Ins' and I have formulas within each reading the 'Check In Type' and 'Last Wk Check In' columns. Below are…
-
Renaming Template Sheets
Hi All, I am new to Smartsheets and currently using a folder of template sheets for every new project. Every time there is a new project, I would duplicate the template folder but then need to rename all the files within it to the new project name. Is there a formula or bracket I can type into each sheet name so I can…
-
Trying to Flag Overlapped Participants in Meetings
So I am trying to find a way to flag if there are the same people in multiple meetings. I am working with a drop down type format for the list of participants, so I am not sure how or if there is a way to compare the individual entries of the drop down to other elements in the column to test for potential conflicts.
-
Flag warning if date is after another within same column
Hi all, Currently having issues with this: I need to find a way of flagging a warning (that'll just say "WARNING") in the thirteenth row of the date column if any of the dates in rows 2-12 are after the date in row 1. I am also struggling to find a concise way of flagging a warning in row 14 if there are any duplicates in…
