-
Convert Numbers (Days) to To Year/Month
I'm trying to convert number of days to year and month. In excel I would use the following formula =DATEDIF(0,[Days closed]11,"y") &" years, "&DATEDIF(0,[Days closed]11,"ym") &" months" Though this formula does not work in smartsheet is there another way to do this
-
Pulling Email Address from Another Sheet but as a Contact
In Sheet 1, a user enters a course code (e.g., BUS 123) in one column. Smartsheet searches for that code in Sheet 2, finds the corresponding program leader's name and e-mail address, then puts them in two cells in Sheet 1. Now Sheet 1 shows the course code in Column 2, the program leader's name is Column 3, and the emailโฆ
-
Formula for only Children rows but excludes Parent rows
Does anyone have any ideas or a sample formulaย where a value can only be applied within a column to rows that are of children level? Soย essentially, if its a parent rowย it doesn't insert any value within the column, but if its a childย row it populates that same column with a value.
-
Embedding IFERROR into an existing formula
I need some help as to how to embed an IFERROR function into thisย formula: =IF([Group Contract Anticipated]438 = 0, "Gray", IF(ISBLANK([Deposit Due Date]438), "Gray", IF(ISDATE([Deposit Sent]438), "Green", IF(TODAY() - [Deposit Due Date]438 <= -10, "Green", IF(TODAY() - [Deposit Due Date]438 > -7, "Red", IF(TODAY() -โฆ
-
Setting "Date Completed" column date based on status change
Hi! I'm trying to set up a formula for my Date Completed column that pre-populates the date in that field to the date where the Status on the same line =ย "Complete". Right now I'm using this formula:ย =IF(OR(Status125 = "Complete"), TODAY(), "") One problem is that it doesn't add the formula for newly added line items. Alsoโฆ
-
Help with RYGB Formula Logic
I can't seem to get this formula to work properly, and my eyes are crossed now. Would someone be willing to take a look to see what I'm doing wrong? =IF(OR([% Complete]21 = 1, Complete21 = 1), "Green", IF(ISBLANK([Start Date]21), "", IF(AND([End Date]21 >= TODAY(), Complete21 <> 1), "Red", IF([Elapsed Duration]21 > [%โฆ
-
Nested IF for Numbers with Greater Than, Less Than, Etc.
Hello SmartSheet Community! I am trying to get a number that has it's own formula in it, to then be the number that is done in another formula on another cell in the same sheet. I'll go over this to ensure there is no confusion about what I am doing. ====================================================== First, my nestedโฆ
-
Calculating Month from Date Column
Hello, I am looking for help with the formula below. I am referencing another sheet and trying to calculate the number of rowsย that fall within January in the 'Milestone Due Date' column. The dates in the 'Milestone Due Date' column displayed in the following format: mm/dd/yy. =COUNTIFS({Project}, [Primary Column]@row,โฆ
-
Formula for Summary of Total Tasks and Completed Tasks
There is a smartsheet template set in the solution center called New Employee Onboarding. In the sheet "30 Day Employee Onboarding Sheet" the tasks are organized by Week and By Day. The formulas for counting Completed: # of # are working for each day, but the Cells that have a Weekly Total are not summarizing for the week,โฆ
-
Counting for this year only (Formula help)
Hi All, I have a sheet that has been populated via forms for the past 12 months. What i would like to do is use a count if formula but only when the date is this year. my current formula isย =COUNTIFS({Pure Gym Issue Type YTD}, "HR / Lateness or leaving early") This works really well but counts everything on the sheet, canโฆ