Formulas
Discussion List
- I've read through a lot of the help topics and others' questions, but haven't been able to find a simple solution to my issue - which I think is fairly simple. I'm trying to add a certain number (Vary…
- I am trying to find an equation that will help me reference text found in multiple different columns to a master column. My "master column" is the column titled "SO Program". Based on the answers bein…
- I have a set of data where I am trying to do 2 things: Find the top 5 highest values in a row. I used a LARGE formula to find the values in the 1st-5th highest spots (seen in rows 9-11). Find the name…
- I am trying to label the overall health of my projects If all symbols on my range are green, I want the overall cell to have a green symbol. If one or more symbols on my range are yellow, I want the o…
- I am trying to use index match to pull a contact name from the last person who worked on the project. This one works which is on the same page but I need a version from a different page =INDEX([ASSIGN…
- My smartsheet dataset is comprised of form submissions. Businesses are required to submit the form monthly, and I need to assign a "red" color to businesses who have not submitted a form in the last 6…
- I have multiple Metrics sheets where I use essentially the same formula to collect information. For some reason I am not seeing, I am getting an error with this one. =COUNT(COLLECT({Row ID}, {Category…
- Hi! Lets say I have a basic formula like this in a "budget" column: =SUM([Week 1]@row:[Week 10]@row) And I also have a cell in a helper column that includes this formula: =WEEKNUMBER(TODAY()) Is there…
- I have the below formula to extra a Quarter based on my column "Expected Close Date". The fiscal year begins 10/1. When I copy the formula to other rows it displays the same number (i.e. January showi…
- I would like to simplify certain formulas that contain common/repeat functions by assigning a variable. This can be done in MS Excel using the LET function (see image below).
