-
formula to add a checkbox in one column if another column is updated with multiple items?
If a column is set up as multiple drop down options, I’d like a formula in another column (checkbox) to check the box if more than one selection is made. Is this possible?
-
What formula would I use to find the Task Name(Column 1) with the soonest due date?
I set up a checkbox Helper column to be checked if the Status column of the task is "not started" or "in progress". I would like the sheet summary to reference the Task Name with the soonest date in the Due Date column if the Helper column is checked. Is there a formula that would accomplish this?
-
Issue with Index Collect Formula
Looking for help! We collect form responses that load onto this sheet below the KPI section. I need to see, at a glance, TODAY'S responses in the Reporting Data section. So I'm using an INDEX COLLECT formula to pull in today's response from each team member. However, I am getting the errors as shown below. I simply want to…
-
CountIF one of multiple criteria are met within the current year.
Good Afternoon. I'm trying to get a count if a specific event is documented to occur within any row in specific columns. This is where I'm at, although unsuccessfully.... =COUNTIFS({Range 1}, "Value1", {Range 2}, "Value 1", {Date Range 1}, AND(IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))))) I need the sheet to count if "Value…
-
COUNTIF the values is lesser than today's date
Hi Folks, I would like to count the names with respective to dates in another column which is lesser than today's date. I used the below formula: =COUNTIFS([Projected CM1]:[Projected CM1], <=TODAY(), [CM1]:[CM1], "Flextronics Wuzhong CM") But it doesn't give the right result, any leads please advise Thanks! Raj
-
Looking for Autofill formula for Agile Action Sheet
Hello, Need a formula that allows a receipients update to automatically autofill into an Agile action sheet. We are building out our WBS and don't want to be bogged down doing a lot of data entry of adding updates to our sheets all day long. So I am looking for a formula that will allow the update that a task recipient…
-
Multiple Data range
Hello, Hope you could help me. How can I get data for Closed AND Scheduled? I can get "Closed" but I also wanted "Scheduled". They belong in only one Column. My formula is below. =SUMIFS({Rev FIle 10.12 Database Range 1}, {Rev FIle 10.12 Database Range 2}, "Tere", {Rev FIle 10.12 Database Range 3}, "Closed", "Scheduled",…
-
Using smartsheet to reserve an interview slot time
Greetings! I'm the HR manager at a company and I'd like to ask for advice on finding a way for candidates to be able to reserve interview slots on a calendar through Smartsheet. Our SB interviews a lot of people and since it's hard finding a time that works for everybody all the time we have set hours for when we do…
-
Harvey Ball Status between % numbers
I want to use the Harvey Balls to flag a status as follows: 70% or less = RED greater that 70% and less than 100% = YELLOW 100% = Green what I've written: =IF([% Complete]@row < 0.7, "Red", IF(AND([% Complete]@row > 0.7, IF([% Complete]@row < 1, "Yellow", "Green")))) I get INCORRECT ARUGMENT SET error on this. If i remove…
-
Can you conditionally format the Gannt Chart in a project plan?
If the status is complete I want the Gannt row to be green, If there is a variance between the baseline end date and the actual end date I want the gannt to highlight variance in red.
