-
RYG based on cell value
Hello, I'm trying to set the RYG ball based on the value of a cell and I can't seem to get it right. If the value is: Greater than 0 = Green Between 0 - 0.5 = Yellow Less than 0 = Red =IF(Remaining@row > 0, "Green", IF((Remaining@row >0, AND(IF(Remaining@row<0.50,))), "Yellow", IF(Remaining@row<0), "Red")))
-
Sheet Summary Formula - (status type) due in next 7 days
I have a manually altered date column [Next BHL Follow Up Date] and a status column with a few options such as "Give Reminder to Attend Appointment" How do I get a sheet summary that tells me the number of Give Reminder to Attend Appointment s are dated for the next 7 days? Thanks, Alix
-
Help with IF statement for % tied to specified value
Hi Team, Can you please help me write a formulae wherein based on the user selection, the % score can be populated. Not Met = 0%, Partially Met = 50%, Met = 100%, Not Applicable = Blank Thanks.
-
Status Formula Explanation
I am trying to figure out how to roll up a status in my project plan. I have been trying to figure it out using this link from the community: Formula to Roll Up Task Status — Smartsheet Community. However, I am getting confused about the "helper" column. If I understand correctly, I need to have a status column where I…
-
Changing a simple Excel formula to work for Smartsheet.
I imported and Excel spreadsheet to Smartsheet and selected to keep the Excel formulas. How ever I get an #UNPARSEABLE. Here is what the formula looks like, =IF(OR([CITY METERSIZE]11="5/8"" BY 3/4""",[CITY METERSIZE]11="5/8""",[CITY METERSIZE]11="3/4""",[CITY METERSIZE]11="1"""),"Small",IF(OR([CITY METERSIZE]11="1 1/2""…
-
IfError returns "incorrect argument"
Hi, I am trying to find values that exist between two Smartsheets. When it does, I should get a checkbox, and when it doesn't, I would like the checkbox to be unchecked. If I use: =IF(INDEX({Sheet B}, MATCH([ProjDef in ASH Custom]@row, {Sheet B}, 0)) = [ProjDef in ASH Custom]@row, 1, 0) I get "#No Match" when a value…
-
Form logic based on field content not working
Hello! I'm trying to build an easy to use form for users in my organization. I want to use the logic capabilities to guide the user down the correct path. The first question, we'll call it Question 1 is a text field and is required. If Question 1 = NA, then Question 1.A should not appear and the user should just proceed to…
-
Can you have a column formula in a column that has a drop down list?
Hi Everyone, My dropdown list is not giving me the option to make a selection now that I have a If formula in it. Column 1 = Team (this is a drop down list with the following teams: Career Development, Instructional Design, Learning Solutions, Leadership Development, Talent and Learning Ops & Infrastructure) Column 2 = LDO…
-
Hi Community. Is there a template for Gantt chart that has conditional format for statuses?
I've set up a Gannt chart with a manual column w/drop down list for statuses of Complete, In Progress, On Hold, Not Started. I want this column to look at the "% Complete" column and if 100% change status of each task to Complete; if < 100, In Progress; if 0% Not Started, if -1= On Hold. Thanks for any help that you can…
-
How to find date having the highest sum when multiple entries per day in a list
I have a running list which collects values submitted by a form. There are multiple users that can submit the form multiple times per day to record a value . I am trying to find a formula which finds the highest summed value for any one day. In this case, the higher the value submitted the worse it is, so I am trying to…