-
I'm Desperate. Can anyone help build this formula? I've been stuck for approximately 60 hours.
Hello! I'm trying to write a formula that I just can't seem to get right. I've got a project with several ancestor levels that I'd like to report on. I'm close, but I just can't seem to get it. I've added a Parent Row helper column with a check box. I'd like the check box to equal True (checked) if the Primary Column is…
-
What formula should I use, and how?
I have many sheets that collect different data on production lots and one sheet that show the most important data sets from those sheets. All the lots have an ID number that is used on all the sheets. I would like to look up that ID number from one sheet, copy a specific cell from that row, and return it to the main sheet…
-
Symbols and percentage of
I need your help to show status as Red, Green or Yellow using this criteria: Green - 91-100 Yellow - 51 - 90 Red = 0-50
-
Sum If Column is not blank
Hello everybody, Hope you are well! I was wondering, is there a way to SUMIF when a column at a row isn't blank? For some reason, I can't come up with a formula that will sum up the volume if the countries column below is not blank. I was able to parent them and then use the below formula, which works…
-
Better way to write this nested if statiement?
I need to replicate this formula a few different times, and I am wondering if there is a better way? =IF([Team-MRR]@row >= [Team-125%]@row, "Top commission reached", IF([Team-MRR]@row >= [Team-110%]@row, [Team-125%]@row - [Team-MRR]@row, IF([Team-MRR]@row >= [Team-75%]@row, [Team-110%]@row - [Team-MRR]@row,…
-
How to calculate the total amount of events happening between certain days
Hello, I have a sheet that lists out football games across multiple codes which happen on specific days, the games are happening from Wednesday to Sunday. I was wondering if there was a formula to calculate the number of events happening each week but only from specific days i.e. Wednesday to Sunday? Thanks for your help
-
COUNTIFS adding checkbox column returns "#INCORRECT ARGUMENT SET"
I'm using a COUNTIFS statement to sum up specific conditions. I have it functioning correctly aside from not being able to incorporate an "Active" column, which is a formula applied to a column that checks the box (true/false) based on a separate condition. When I attempt to add this final condition, I encounter the…
-
Stoplight formula based on % Complete
Hi all... I'm using Smartsheet to create a project plan. For each task, I have a stoplight column (red, yellow, green). I also have a "% Complete" column, and Baseline Start and Baseline Finish columns. I would like to set a formula to display a stoplight based on percent complete and # of days to Baseline Finish. So, for…
-
How can I chart the last 7 days that contain data?
Hello, I am capturing audit data utilizing the web form for smartsheet, and would like to use a line chart to show average compliance per day, for the last 7 working days. With the holiday weekend that just occurred, I have a 3 day hole in my chart. I have been brainstorming and am trying to come up with a formula that…
-
How do I cusomize system generated date created?
This generates a date and a time. How do I customize so I just get the date. I can then use a formula to count across a date range. I cant if thee is a time in the cell too.