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).
I have data coming into a sheet (Month column) that I need to separate into Month (Helper - Month) and Year (Helper - Year) columns. I have worked out how to get the month separated using the LEFT fun…
Intake Form sheet for each site that has submitted their monthly activity form. Entries will be in this sheet for the entire current year, so each site ‘might’ have up to 12 monthly entries. Each of t…
Hello, I am trying to create a sheet that calculates 60 school days from a specific date. It needs to omit weekends, holidays and breaks. I used the following formula and it is still not calculating c…
I have two reference sheets that I'm trying to connect to another sheet that will serve as a log. How it works: User enters information (VTH Code is associated with a vendor price on both the referenc…