-
Relative Default Date in Forms
I'm looking to do a 'Needed by' date in a form and I would like the default to be a relative Today + 2 weekdays. Anyone found a way to nicely do this? ie. Today is 4/29 , the form will default to 5/1 as the suggested Need by date that can be overridden by the user - say they give us 1week instead - 5/6 that should be good.…
-
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…
-
Possible to create multiple linked templates?
Hi All, Hoping there's a few Smartsheet super users out there that can help! I've created a pretty flash client specific dashboard which pulls in from one master project template, which is is also linked to about another 10 seperate report sheets. Without cloning and linking it all up again, I was wondering if there was a…
-
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],…