-
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…
-
Voting using Symbols Formula
I want to collect "votes" from multiple voters (columns Voter 1, Voter 2, Voter 3, Voter 4, Voter 5, Voter 6) using RYG Balls in a sheet. Each row represents an item that is received through a form that must be voted on. I have a "Tally Vote" column that I want to use as a summary of sorts to reflect status at a glance in…
-
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…