-
Reference the value in the row above and change this cell value as a result
In excel I would use the formula: IF(A2=A1, C1+1,1) What this allows me to do is say, if the value in column A on this row matches the value above it, then increment the value in this cell, if not start again at 1. When you create a formula like this in excel you can fill it down and therefore have every row reference the…
-
Show Multi-Contacts with a JOIN(COLLECT(...) formula -- working, but not showing as contacts
I have a Directory Sheet ('Sheet 2 -- Directory': https://app.smartsheet.com/b/publish?EQBCT=a3e35afe3e02404692195182d00936a4) with a list of Teams, Departments, and Contacts. I want to pull the Contact(s) into another Sheet ('Sheet 1 -- Pull Into Sheet':…
-
I Need help and support on a formula I am using
=IF(HAS({1st day of the week}, Date@row), OR(HAS({2nd day of the week}, Date@row), INDEX(COLLECT({Clinical Placement Tool Status}, {Hospital Site Name}, [Hospital Name]@row, {Unit Name}, [Unit Name]@row), 0))) Is the formula I am using it is partially working. When I look at the results in column where it should be pulling…
-
Count formula not working with helper column on first sheet, returning all zeros
This is the formula I have =COUNTIFS({Overall Grade}, >=4.5, {Fleet}, "717", {Mod Helper}, "100") On the main sheet, there is a helper column which converts the module number to a set 3 digit number (i.e. 102, 141 helper column will show 100) No matter which return the helper column has, all return zero.
-
When Approvals are Declined/Rejected
I have an approval workflow that includes three people: Program Manager Finance Representative Payee The Approval Status column for each is locked and updated automatically via the request approval workflow. I am trying to figure out the best way to handle if any of them click "Reject" rather than "Approve". First, the…
-
Need to remove timestamp from date field
Hi community, I am trying to remove the timestamp from a date field that feeds from a data shuttle. I have tried to use the DATEONLY formula, but I am getting an error message of: INVALID DATA TYPE. Within the new column I'm trying to build, I tried both the column type of both date and text/number, but I still can't get…
-
Can't see my photos in Smartsheet ! Help
Hi everyone, I'm new to Smartsheet and having trouble with pictures. I uploaded some photos to my project sheet yesterday, but now I can't see them. The cells just show a little icon instead of the actual image. Is this normal? How can I make the photos show up? Also, is it possible to add videos to Smartsheet? I'd like to…
-
Extracting all text from a cell to the right of a symbol
Hi, I'm trying to extract all text from a cell after the hyphen "-" symbol. There may be a long text string after the hyphen, not a set number of characters. I can get it to extract words to the left of the hyphen using the LEFT function but when I try to use RIGHT it cuts off part of the text? Top row formula in Short…
-
Find the position of an element in a dropdown list
I have two columns: Column One: It's a multi-select dropdown list with the names of products (the quantity of selected products can be very long) Column Two: It has the quantities of each product in the same order as Column One, separated by commas. Example of one row: Column One (dropdown list with multiple choices):…
-
Trying to pull data from one sheet if employee number matches
I have one sheet with employee numbers and a score they have (1-5). On a second sheet, I have a total list of employees per row and then there will be a column for each score, 5, 4, 3, 2, 1. I want to be able to say Employee 123456, match that number on the first sheet, then count how many 5 scores there are for that…
