-
Using working day calendar
I need to add another date column that will be updated with a formula. This is not connected with start and/or finish dates. I would like for this column to use the working day calendar to return a date that is a working day, just like the start/finish dates. Something similar to the below where I want to have a buyoff…
-
Looking for a formula
=IF(AND([Email: I do not want vaccine]@row <> "", COUNTIFS([Email: I do not want vaccine]:[Email: I do not want vaccine], [Email: I do not want vaccine]@row) > 1), "Duplicate") The email is not always mandatory which is why I need to be able to leave blank cells alone and if there is a true duplicate I need to be able to…
-
Expected Progress
Hi, which formula can I use to calculate the expected Progress (depending on the current date)? Thanks
-
Metric Sheet, Countif value appears even once in column = #UNPARSEABLE
Hello everyone, I am trying to create a metric sheet, referencing another sheet's column. The column is a multi-select drop down, so I want to include in metric even if its one of many entries in cell. Any suggestions on why my formula is incorrect? Thanks. =COUNTIF({Sheet - TPM Request Intake KTG}:{Sheet - TPM Request…
-
Average(Collect with OR Function
Hi there, I am trying to average a subset of items based on multiple criteria: Intent is to average the score if the following criteria apply: *Period equals review period selected in absolute cell reference *Analyst equals analyst in that row *and the function includes TM-CRNI, TM-CARFI, FIG-CRNI, FIG-CARFI, or Account…
-
Formula for Reoccurring Tasks - Different Frequencies
I am looking for creating a sheet where team members can added tasks that happen more than once via a form but am getting stuck on the formula to calculate all of the due dates. here are the scenarios we need covered: Weekly = 5 business days in between Weekly - Specific Day of the Week = Due once every week on the same…
-
Count if with Multiple Columns
Hi, This might be a simple question but I've been a little stumped by what syntax to use and hoping you can help. I have one column (Test Case Type) that has 3 options to pick from 'Original', 'E2E', or 'PAT'. I have Another column 'IC Review Status' where the drop-down options are 'Not Started', 'In Progress', or…
-
Is it possible to create a conditional rollup for $'s OR display the max value for %'s?
I am working on a smartsheet tracker that can track the cost savings of specific projects on a month to month basis, then rolls up the total YTD savings. There is also an option for the users to enter their project progress as a percentage, in which case I would want the YTD column to display the maximum % from the year…
-
How to count from a wider range by a given value in a column?
I want to count how many employees has experience of available projects, my formula is: =COUNTIFS([Employee A]1:[Employee D]5, ="YES", [Available?]1:[Available?]5, ="YES") I got an error: #INCORRECT ARGUMENT SET If I change the first condition to "[Employee A]1:[Employee A]5, ="YES"", it works. Looks like COUNTIFS doesn't…
-
Change formula to show %
I used this formula to get my % in my Sheet Summary: =COUNTIF([Employment Status at Enrollment]:[Employment Status at Enrollment], ="Manufacturer") / COUNT([Employment Status at Enrollment]:[Employment Status at Enrollment]) I would like it to show up as 40% (round up). Any assistance would be appreciated. Thank you!
