-
Formula for Lights
Hi all, I have a sheet that contains fields for "Preparer Due Date" and "Preparer Status" and am trying to add in the following logic to a formula: If Preparer Status is "Complete" OR Preparer Due Date is earlier than today AND Preparer Status is NOT "Complete", then put a green circle If Preparer Status has a status of…
-
Checkmark Column Formula
Afternoon, I have tried every formula in the book to count all check marked boxes within a column. Can anyone just write the formula that works for them? This is the formula I am trying to make work- =COUNTIFS([Construction Complete- Not Submitted]2:[Construction Complete- Not Submitted]254, 1)
-
Using a Risk flag
I want the flag if the date is past due, but it's also giving me a flag if the end date is blank. what am I missing here? I tried to add another NOT statement and ISBLANK, but then was just getting errors. =IF(AND([End Date]4 < TODAY(), NOT(Status4 = "Complete")), 1, 0)
-
Countif formula, I want to count if anything is in a column
I can't figure out how to count a column if there is anything entered into the column, can anyone help?
-
Multiple IF statements
Hi Team, I tried to follow the solution mentioned "regarding combining multiple IF statements", I get an Unparseable error. My formula: =IF([PM Effectiveness]@row=🤩 Strongly Agree,"5",IF([PM Effectiveness]@row=🙂 Agreed,"4",IF([PM Effectiveness]@row=😐 Neutral,"3",IF([PM Effectiveness]@row=😞 Disagree,"2",IF([PM…
-
summing up data for multiple people with text data?? and no Sheet Summary function
Hello, I'm hoping someone will be able to help me, I'm a Government user so I don't have access to all the functions that a regular user of Smartsheets would have, like Sheet Summary. So i may not be able to do what I am wanting to do, or i just can't think of how to do it. My team has a simple task tracker where we track…
-
Calculating Average Time for each member of a team
Hi everyone, I am new to SmartSheets and Excel formulas in general and would like some help please. I would like to calculate the average time in months that it takes for a team member to complete tasks. For example, I have a date created column for every task and another column named "Team member". I would like to…
-
Countif of children cells
Hello everyone! I got stuck on a formula that I need as KPI to monitor a project. I need a formula similar to the one that appears by default and that shows the percentage of completed task per macro level. In my case, I need it also for the other activity statuses, such as in progress and not started, so that in the end…
-
Subtract minutes from Hours
Greetings, I'm trying to subtract minutes from a set number of hours and display the amount of time left in HH:SS. For Example: There are 10 hours available for testing but totally the environment came up 35 minutes late. I know it is something simple but I'm missing it.
-
Quick Formula Help
Hi Community, I'm working with a colleague to create a column formula with multiple IF conditions. Just struggling to get our initial chain going before adding in others. What we need: -We have a column entitled "Submission Type" that contains a dropdown list of different submissions. Each submission has an estimated…