-
Looking for help with countif formula
I'm having some trouble with a countif formula, looking for some assistance. My goal here is to count the number of time the Created Date is last month and that the service type is "Trade Database - Add Part Number(s)" When I enter the formula below it works great! =IF(MONTH(TODAY()) = 1, COUNTIFS({Genie Archive Created…
-
Formula Help
Hello! 2 things... I have a sheet summary where I am using the formula below to count the true number of students on the sheet even though they can be listed multiple times per semester. It works like a charm because the email address is the column used because there is no way there could be a typo there. Sometimes editors…
-
Calendar View - can't drag tasks when Due Date uses WorkDay function?
My SmartSheet has Task Due Dates that are calculated using the WorkDay function. For example, if a recurring monthly task is due on WorkDay 1, that calculated Task Due Date would become Monday, January 3rd, rather than Saturday, January 1st. Approaching the dates in this way makes it easy for us to rollover the Task List…
-
Formula to pull data from one sheet into a different sheet.
Hello Smartsheets, I am building a sheet that will track an employees attendance of our monthly trainings. Sheet #1 is the raw data, Sheet #2 contains all of the formulas and combines all raw data in a legible way. See photos below. Sheet #1 This sheet contains all raw data received from the attendees of each monthly…
-
#UNPARSEABLE Error
I've tried this formula in Excel to ensure I have the correct syntax and that it actually works...which is does. But when I recreate the formula in Smartsheet and reference the appropriate Smartsheet, I receive the #UNPARSEABLE error. =SUMIFS({Sheet - Project Intake with Form Range 4}, {Sheet - Project Intake with Form…
-
How to get distinct values from a column, then shows their maximum number?
How to create a formula that can get me the distinct name list from the left table then get their max values? Please help me
-
Sheet Summary Column Formula - Created = Today - 7
Hi, How would I create a summary of [Column A] for all rows that were created 7 days ago? I tried this, but it didn't work. =SUMIF(Created:Created = TODAY(-7), [Column A]:[Column A]) Response was: Invaild Operation Please assist. Thank you!
-
Creating dashboard chart using "Date Created" column?
Hey everyone. Here is what I'm hoping to do. I have a single smart sheet containing containing about 4 months worth of lines. I essentially want to create a bar graph showing the number in lines created by month. (So how many were entered in June, July, August, September). I have an automated date created column to…
-
error Unparseable in formual
i have this formula and want to add one more critiria at the beginning. this one works good. IF([Fint Cross]@row = "NA", IF([FTST Dock Date]@row - 8 < TODAY(), "Release Job", ""), IF([Fint Cross]@row - 8 < TODAY(), IF([Main Frame %]@row > 0.5, IF([CH % comp]@row > 0.5, "Release Job", ""), ""), "")) Tried this by itself and…
-
Help with Creating IF Formula * PLEASE*
WHEN (NO actual survey date entered yet) If Scheduled survey date is beyond 7 days from today date – Green If schedule survey date is within 7 days from today date – yellow If scheduled survey date is today or past – Red Once an actual survey date is entered it is – blue *** GOT THE FIRST PART BUT CANT FIGURE OUT HOW TO…