-
% Complete for Checkboxes Marked
Hello, I've looked into similar questions, but I'm struggling in how to write the formula for this. I'd like to calculate % complete of checkboxes marked for each column. Then I plan to represent the % complete in either a dashboard for reporting purposes. From what I read, it should be the =countif formula, but cannot…
-
Formula help for date <90 days and text "includes"
So really stumped on this one, my formula is working with the exception of the text including "Test". I need to have a star (1) put into this cell IF: Column [Expiration Date] is <= 90 days from today AND another column (Client) includes the word "Test". My current formula (auto-generated) is not working, any help is much…
-
Need Help To Target Parent Children Field to Trigger Update Request Communication
Requirement : Email notification cascades to other parties as previous tasks get [Status]completed so that they can start the next task. 1.Due Time for first child to take the timestamp from parent and add duration 2. For other children look at the sibling above Auto Numbering column for Parent and Child Assignee at level…
-
Using Smartsheet to book meeting rooms
Dear community Has anyone used Smartsheet as a calendar for meeting rooms or other spaces. The principle is basically the same as outlook. The basic concept is pretty straight forward and that I managed to implement with a form, calendar, etc. The challenge obviously comes when you want to have advanced features such as…
-
Workaround for if statement from form
Hello, I was hoping to get some help with a formula/workaround in the following scenario: -A client fills out their information as the "submitter" in a form (Column 1). -The client is asked in the form if they are also the authorized representative from their organization to sign a DocuSign integration (Column 2 - Is the…
-
formulate total based of drop down
I have a column of drop down selections (hold, open, and closed) additionally I have a column that has PO values for all line items. I want a cell to keep track of the dollar value of only the hold and open drop down selection. can any one help me with such a formula?
-
Distinct CountIFS Statement
I need a little assistance... I was able to get the formula to partially work using =count(distinct but, it was not taking the name cell into account and returned the same number in each row. I need a distinct count of PrAbv based on P Name. I got "#inccorect argument" when I changed count to countifs. I'm sure it's…
-
Formula to count number of Days and not counting Status
Hi everyone. I hope everyone is doing well. I was wondering if I could please get some help. I have a tracker named eAPP, I am trying to count the number of Days since Assigned for 0 to -12 days but exclude in the count if the Current Status is "Completed". I have tried so many formulas, but nothing is working. Thanks.…
-
Mastering Parent-Child Row Relationships: Solving the '#INVALID DATA TYPE' Dilemma in Health Status
I am working on a sheet where I want the parent rows to reflect the health status of their child rows. I have defined four categories, which are "No Risks," "Some Risks," "Overdue / Risks," and "Canceled / Done / On Hold." I have created a formula to achieve this, but I want to establish a rule that only when ALL child…
-
Average symbols for growing number of columns
Hello all, I know this is likely possible, but I've been struggling to think of the most efficient process. Below is a sheet I'm working on, where trainers enter progress for a trainee in a given "soft skill." These trainer columns will be added automatically on a daily basis via an outside Power Automate flow, while the…