-
Converting text to Date to populate Gant & Calendar App.
I have an Allocation sheet where I need the user to choose the month in the "Month" column and the 'Start' populates with the first date of the month and the "End" populates with the last date of the month so I can have a start and finish date to show the resource and Allocation on a Gant and Calendar app. I have tried to…
-
Cross sheet Index Match suddenly not working
Hi guys, Hopefully someone can give me some help on this. I have set up many cross sheet index matches that have worked without any issues for 1-2 years. I logged in to Smartsheet recently to find some cells now returning REF#. The formula is correct, but I re wrote / re linked the formula to see if it would fix the issue.…
-
Checkbox Functionality
I've been converting another group's GoogleSheet into SS. Is there a way to create functionality that limits the checkboxes in a column to one true value? Meaning, if a different box is checked, all others are unchecked? Essentially, the true would then feed a vlookup for chart formulas on another sheet. I could obviously…
-
IF Formula Error
Hi SmartSheet Community, I'm having trouble with an IF formula. I have a list of employee titles in one column. I'm trying to use a formula that says if a person's title = "Director" or "Senior Director" return "Yes", "No" I tried to use both conditions but I keep getting the UNPARSEABLE error. Can I please get help with…
-
Is there a workday.intl equivalent in SmartSheet?
I am looking to pull in a google sheet used to manage project schedule that uses a 6 day work week to calculate schedules. For example one cells formula is: =IFERROR(if(E69="Mail Date", F69,if(G69="First", workday.intl(AN69,-4,11,Holidays_USPS), if(G69="Standard",workday.intl(AN69,-6,11,Holidays_USPS),"NA"))),"NA") Is…
-
Trying to average values from one column based on conditions of two other columns.
Where I have Columns "Employee Name", "Score Week", and "Week Score" I want to average the "Week Score" for the "Employee Name" where "Week Score" is a value of "1", "2", "3", or "4". I started here: =AVG(COLLECT([Week Score]:[Week Score], [Employee Name]:[Employee Name], [Employee Name]@row, [Score Week]:[Score Week],…
-
How do I calculate dates from a cell whose value is based on a Formula?
I have a cell I would like to calculate a date that is based off another date minus the value of another cell that is calculated off a separate formula. So I did =[Install Date]@row - [Projected Lead time]@row The issue seems to be that [Projected Lead time]@row is a calculated =IF formula whose value is in number format.…
-
Trying to combine IF, OR, & AND
Hi all, As the title states, I am trying to create a helper column that is checked or unchecked based on a few conditions. I want to check the helper column box if statements 1 and 2 are both true or if statements 1 and 2 are both false. I had written: IF(OR(AND(statement 1@row = 1, statement 2@row = 1), AND(statement…
-
AverageIF- Date range and multiple criteria from SS source
Hi, I keep getting unparceable, please help! Need the average of all days in source 1that meet this criteria: source 2 ="closed", and source 3 has a date range of 1/1/21-3/31/21. Source 1-{Tracker Range 8} Source 2- {Tracker Range 4} Source 3- {Tracker Range 3}
-
Count how many are late or on time in a month
Hello! I'd like to count how many TCPs are Late and/or On Time a month. My sheet references another sheet to count how many TCPs are completed per month. And on the sheet below, that's where I want to say how many are Late or On Time for the month. If I need more columns, please let me know. Thank you!