-
ISNA Excel Formula
I am trying to recreate an excel formula in Smartsheet that looks for the column Header word in the proceeding columns within that same row. If it finds the word in that row, it then places the word in the cell that the formula exists. So if the formula is in [Apple]1, it searches a specific range of columns in row 1 for…
-
Can you auto populate task dates based on the entire project end date?
I have different marketing tasks where their completion dates revolve around an entire projects completion date. For example, there are tasks that need to be completed 10 days before project completion date, 20 days prior, 30 days prior, etc. Is there a formula I can use that auto fills task due dates based on the project…
-
Complex formulas ammendment
Hi All, I have an existing Smartsheet that has some relatively complex formulas to count the the status of an action as there are several conditions for an action to show as "Open" and "Overdue". Over the last few days, we have modified the sheet further by adding columns and each added column now comes under as added…
-
Highlighting Gantt Chart Date Columns
I have several projects that were suspended due to Covid issues but are starting to open back up. I have to push out everything due to this suspension and I would like to highlight (or just delete/hide) those date columns during the suspension period. Is there anyway to do that? If not, can I submit that as a feature…
-
Multiple IF/AND for duration and status
Hi Community, I am trying to structure an IF/AND formula to reflect the following conditions: IF [Duration]@row <> 0, AND IF [Complete]@row =0, "Not Started" IF [Duration]@row <> 0, AND IF [Complete]@row =0, AND IF[Complete]@ previous row = 1, "In Progress" IF [Duration]@row <> 0, AND IF [Complete]@row =1, "Complete" IF…
-
Locking a Formula in a Column
I created a formula in a column that I do not want people to be able to change, but to still function as people add new information in the rows. By locking the column, will the formula still work (the cell will still populat/update) when the reference cell in the row is updated?
-
rollup formulas
I have personnel sending out emails. I want to track how many total emails each person has sent in a given city they put a checkbox after each email has sent. I would like a formula that would total the checked boxes from each person. is that a countif? countifs? thanks, SGF
-
CountIF Formula issue
Greetings, I'm currently attempting to create a CountIF function that counts the number of Ungroomed Stories that start within the next 30 days. My formula is the following: =COUNTIFS([Issue Type]:[Issue Type], "Story", Labels:Labels, ISBLANK(@cell), Status:Status, "To Do", [Target Start Date]:[Target Start Date],…
-
How to Create Formula to return Fiscal Week
I have 1 column with Start Date for Fiscal year & week 2nd column is end date for fiscal year & week I want it to return 3rd column where i have FYYRWK This is all housed in a separate smartsheet. Ive tried a few different articles on smartsheet, but cant seem to get one where i want it to be = or Greater than & less than…
-
Logical Condition with forms
Hi, Can we make a logical condition with forms? For example, I have the first selection for Gender and if someone select "male" or "female", it will show different forms for each selection.