-
How to link same type of multiple data on a single row from one Sheet to another.
Good morning, I have two Smartsheets that I want to link and get some data. Smartsheet 1 has the person's name (and some other info) and Smartsheet 2 has their certificate data. I'll add a Cert column on Smartsheet 1, to link the cert data from Smartsheet 2, however, some names have more than one certs. How can I link…
-
Counting totals with checkbox rows
Hi there, I am trying to set up a formula where it will add up all of the "buying price" column where "sold" is checked. I want to see the total value of all sold units, based on the check box approach. See attached image. Can any body advise how to achieve this? I've been messing around now for a long time, and I cannot…
-
VLOOKUP with conditional criteria.
As mentioned in a couple of previous threads, I've created a complicated cross-sheet formula with several different reports. What I'm trying to do now is have a sheet populate whatever information is found in Range 1 if it meets the conditions mentioned. So, if anything is entered into Range 1 (Outlet) with the condition…
-
Excel Translation
How do I translate this to Smartsheet? =IFS(C3="black",1,C3="blue",2,C3="red",3,C3="green",4) I realize there is no IFS function an that I need to nest the information, but I can not get the formula worked out. =IF[Color]1=Black,"1"
-
Help with formula please
I am trying to sum "Echo Specific CME" that fall between the dates of 5/1/2018 to 4/30/2021 on column "Date of CME". I keep getting an "Unparseable" error. Please let me know what I am doing wrong... My formula: =SUMIFS([Echo Specific CME]:[Echo Specific CME], [Date of CME]:[Date of CME] >=(DATE(2018, 5, 1), OR([Date of…
-
Dashboards and Graphs
I am using smartsheet as a sort of CRM replacement at the moment and I need to know if there is a way to get my data into a dashboard for some quick reporting. The issue I am running into is that I have the sheet setup to track information for specific data on each row that is non-numeric. Column-Column-Column-…
-
using COUNTIFS and Contains when referencing different sheets
Trying to count following: Any row on reference sheet in the applications column that is equal to "EpicCare Acute", Training Impact Column ="High" and Role column contains "MD" (it is Text data type with entries separated by columns, not multiple select dropdown). I have tried everything and works fine until I use…
-
Conditional formatting not being pulled through linked cell?
I have a sheet with some numbers that are colour coded using conditional formatting. I am referencing these cells on another sheet via Linked Cells. However the conditional formatting is not being pulled through to the second sheet, instead it's just showing the numbers in plain font. I've got conditional formatting to…
-
Help w/cell validation (true/false)
I'm having a bad case of the Monday's! I have a formula that works but I need to modify/reduce it to fit my needs now. I have a table that I look for certain phases and it it's there then "true" and if it's not then "false" Currently the C/H/M Incorrect Helper format formula work: =IF(COUNT(CHILDREN([Step Label]@row)) > 0,…
-
Calculate new start time for whole schedule
Hi there! As an event organizer, I want to automatically update my schedule in smartsheet when a session takes longer than expected. Column 1: Start Time (HH:MM) Column 2: End Time (HH:MM) Column 3: duration in minutes Column 4: new start time (HH:MM) how can I arrange a formula so that once entering a new start time in…
