-
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.
-
Is there a way to have a cumulative formula?
Hey everyone, I would like to know if there's a formula that calculates the cumulative time because I have to drag it down everytime. I have 3 columns: 1) Task 2) Task Duration 3)Cumulative time I know that for row 2, I can just do [Task Duration]@row + [Task Duration]1, but I can't do that for row 1. Also, by using this…
-
=INDEX =MATCH to pull up dates.
Hello, I've been wracking my brain trying to understand why this doesn't work. I have a sheet with some project-related data including the columns "START DATE" and "END DATE" which are date columns because they have dependencies on the duration column etc. I'm making a new sheet for resource allocation, and I need to bring…
-
Process with parent row
Hello, i have a sheet with all quoatation i sent to client and some of them moved to status "approved"/"void". the process is after i get the PO, and after i finish the job that the client buy from me i forward request to my worker for issue a invoice. i have the summary for all quotation i sent where now is it (waiting…