-
Automated Formula Question
I have two Smartsheets: Config and Labeling. Both Smartsheets have Document #'s in them. The Config Smartsheet has multiple Document #'s in each row, in different columns, while the Labeling Smartsheet has one Document # in each row, all in one column. Both Smartsheets also have a Status column with the same dropdown…
-
Adding new option to Health color-coding
Hi Community team, I have a task health column in my project plan sheets that color-codes rows according to status and relative dates. I am attempting to add a new status option to my project plans (Deferred), which I'd like to be color-coded as gray, but something about the formula syntax is not working. I want anything…
-
Import Specific Entire Columns from one sheet to another
It seems something this simple is overly complicated. I can copy, move, manipulate rows...but columns? Why is this so difficult? I have tried VLOOKUP and INDEX. Both I feel I am getting nowhere. Sheet 1 (Master, holds all data) I need to pull specific columns only to Sheet 2. As rows and data are added to Sheet…
-
#INVALID DATA TYPE, when trying to Column count Quantity of Rows with a Date by Month.
I believe I am close, but no cigar yet... I have a request sheet that records a completed date in a Date Column (ie. '01/07/22'). I am trying to count the # of requests that are completed by Month type for a report. Ideally would like to report how many requests completed in January, February, March, etc... I realize the…
-
SUMIFS on Sales Pipeline
Just setting up a new 2022 Pipeline and the SUMIFS is giving me a headache with the dreaded UNPARSEABLE!! I am wanting to add up the value of sales of a particular product if the deal has been concluded. "2022 £££" is the column containing revenue derived from each product sale "Sales Stage" column - I want to add up those…
-
Sheet set up
I want to have a column that has a yes/no option. Which I have set up. I'd like that answer to be triggered based off of the values in two other columns macthing (or not). Please help!
-
If cell is blank put N/A
I have created the below formula to check the contents of a cell and lump it together neatly. However, if the cell is blank, I would like it to return a result of N/A. How do I go about that? Not all cell's will have data and I don't want the summary to be confusing if it's just left blank. ="ABC:" + ABC@row + CHAR(10) +…
-
Count if on two columns
I have a sheet that pulls from another, I need to do a count if for two different columns. I use this formula for one, how do I add another? =COUNTIF({Date 2}, [Start Date]@row) I need something like: =COUNTIF({Date 2}, [Start Date]@row), =COUNTIF({Review Board}, [ReviewBoard]@row=XX) It is an agenda sheet that has a set…
-
Automate the copying of rows and deleting previous versions
I'd like to automate the copying of a row into a secondary sheet when a cell is updated. Then delete any older versions, on the secondary sheet. I have already created a system column to create project ID's. I can find previous versions of the copied data, but I'd like to automate it so that when the new information is…
-
Removing Rows at Bottom of Sheet - Affecting Formulas on Dashboard
There are about 10 blank rows at the bottom of my sheet that keep coming back, even after I delete them. I either need to know how to permanently delete them or how to adjust my formulas to not include them because they are affecting our dashboard results. Any help or advice anyone has is welcome. Thank you!