-
Formula to check box in sheet A based on data in sheet B
Will you help me write a formula in Sheet A that will do the following three things? 1) Look for a checked box in Sheet; 2) if the box is checked, then look to see if the cell in the same row - next column contains "100%"; 3) if both are true,
-
Index and Match for multiple instances
Hi everyone, I'm stuck with a formula that partially works for what I originally intended. However, it is only returning the first value it finds. Let's say I have a sheet and I paste a name in a column called 'Contractor Name'. Then, the column I have my formula in, let's call it 'Archive Match'. I want the formula in…
-
Formula for the arrow Visual symbol
Good Morning, I'm looking for a formula for the arrow symbol, If the priority of a particular project changes then I would like for the arrow you move up or down within the column. I hope this makes sense, and thank you for any help that is given.
-
RAG Ball Status Formula
Hey, I have put together a formula for RAG ball on a project Smartsheet. =IF([Variance2]@row <= -2, "Green", IF([Variance2]@row >= -7, "Red", IF([Variance2]@row <= -6, "Yellow", IF([Variance2]@row = 0, "Blue")) It is half working at the moment except it won't turn blue when there is a zero and for some reason isn't picking…
-
Workflows - How to remove a respondent from a workflow once they already responded
Looking for help on removing a team member from a workflow "request for update" once they have satisfied the request (aka already responded). My current workflow is a request for an update 7 days prior to a due date. Say a team member responds when they receive the request and they provide the update. Since my alert is set…
-
Automation - need a required for meeting reminder
Hi all, I currently have created a form to which PMs submit their project to discuss on a weekly call for authorisation. I want to incorporate a 'Required Members' reminder for the likes of VPs and stakeholders which they then reply to if they can make the cal. I have made a required members tab, with multiple contacts in…
-
Preventing actions on certain days
I am creating a project plan that will be used as a template for several similar projects. The project has several shipments dates for "in process materials" to client for testing, but such shipping cannot occur on a Thursday or Friday. How can I set a rule that if the project automatically says something show ship on a…
-
COUNTIF Formula in Multiple Dropdown Box but Exclude a Word
I’m trying to create a COUNTIF from a multiple drop down column (referencing another sheet). Two words are similar: Active and Inactive. If I use CONTAINS, it counts both Active and Inactive: =COUNTIF({Certified Roster Range 1}, CONTAINS("Active", @cell)) If I use HAS, it counts when Active is the ONLY item listed in the…
-
Average
@Leibel Shuchat Hi Leibel- Thank you so much for your help yesterday for the formula of Create Date - Modified Date= Time Spent. I wanted to ask if i could convert the results to number Xd : XXh : XXm Also if you could help me on getting the average in "Sheet Summary" for each month per associate? I have 9 other associates…
-
How do I extract data from a column that represents a week or month?
Lets say I count apples sold and I input the data in column [Number of apples sold] which is next to a date column. Now I want to find out how many apples I sold in a given week. I use this formula: =SUMIFS([[Number of apples sold]:[Number of apples sold], Date:Date, WEEKNUMBER(@cell) = 44, Date:Date, YEAR(@cell) = 2021)…