-
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…
-
Need Formula Help Multiple Date Columns, count days, if blank choose other column
I have Multiple date columns for approvals. I want to find the number of days between columns, but some are blank so I need it to choose another date column based on what I set. I've included example data.
-
Is there a way to use a checkbox (or formula) to bypass a required form field or turn it off?
We have a contact information form that will be distributed quarterly so the respondents can provide contact info changes and updates within their organization to ensure that we always have up-to-date information. Most of the fields are required however, in the event that the respondent has no new changes or updates to…
-
Formula to calculate the average number of days between all dates in a range
I have tracking sheets that record "sent" and "executed" dates. I am attempting to set up Sheet Summaries to determine the average number of days between all "sent" and "executed" dates in the sheet. (I want to do this without adding an additional column and calculating averages for each row). It seems I need some type of…
