-
Sum Children that Meet Criteria out of Total
Smartsheet Community: I am Trying to Sum the Children with Criteria in a Different Column. For Example: Column A: Total =100 Column B: In the Sprint Column A Formula: 50 out 100 in Sprint Not sure if I start with Sum the Children or If Count Children First. Tried both but unsuccessful. Thanks
-
Best formula?
Hello, I've tried searching previous similar questions but i think most are more advanced than I need: I have a column which is a drop down with 2 options: column name: 'Total people said 'YES' to Welsh at meetings' option 1: At least 10% and less than 100% of attendees option 2: Less than 10% of attendees i want anotherβ¦
-
Change RED/YELLOW/GREEN symbol based on 'At Risk' containing set # of occurrences
Hi - I'm trying to get the 'Project/Phase Health' column to change to YELLOW if I have 1 to 2 'At Risk' task, but to be GREEN if all task have empty 'at risk'. I tried to SUM the 'At Risk' column as I thought 'At Risk' = "Yes" means that the cell had "1" in in (equivocably). What's the formula to say that IF(SUM of 'Atβ¦
-
Formula to find many times an employee failed on a task
I am trying to write a formula that will keep track on how many times an employee failed to document properly for the last 28 days. Below is the formula I tried with no success ( I have replaced the employee's last name with asterisk's for privacy). I have also attached a screenshot of the sheet I am tracking on. Any helpβ¦
-
Metric Sheet for dashboard
Hi, I am working on a dashboard with a Metric sheet. I have the formula to count my tasks =COUNTIFS({Emerald Workflow - Status}, @cell = "completed"). What I would like to do is add in only if date submitted or completed in the last 7 days. the Date Submitted is a system date. Is this something we can do? Kirstie
-
Get the value with the latest Date
Hi Experts, I need help in getting the value from the item column of Test Sheet1 which has the latest date and put it in the test sheet 2. I am trying to use, join(collect(Item sheet1 , Date, max(Date(@cell)) but not working. Can you help me with the correct formula? And second question, what if I have 2 reference sheetβ¦
-
Using CountIf to get values from multiple sheets
Hi Smarties, Just out of curiosity, is there a simpler formula when consolidating data from multiple sheets with the same column name? For example, I have sheets Test 2 and Test 3. Both have status columns and I would like to count how many In Progress in my roll-up sheet. It works when I do the following formulaβ¦
-
How do I count how many projects are "In Progress" or "Completed" ?
HI There, I feel this should be easy to figure out but i cant seem to! PLEASE HELP?! I have a column called "STATUS" , I have a drop down menu with the following under Status STAUS On Hold In Progress Cancelled Completed How do I show / count how many projects are "on Hold" or "Completed" or "Cancelled" Ideally this willβ¦
-
Display date and time in India time from GMT
Assuming Created time is captured inGMT datetime, I would like to display Indian standard time in another column. I referend few timezone conversion samples, but its not working if the timezone time with excess of 30 min. India timezone is 5 hrs 30 min ahead of GMT, formulas discussed in the forum works if GMT+5 and notβ¦
-
Conditional Formatting based on Date
All, I would like to create a conditional formatting based on a date. Use case below: Column A is a date - I would like Column B to turn yellow if it is under 10 days from Column A date, turn orange if past 15 days and turn red if past 15 days. Is this possible? Would I need to create a formula? Doesn't look like I canβ¦