I have two different sheets. Sheet A is a list of contacts by office/division. Sheet B is a sheet that contains an approval path, based on the office/division. I want to use a formula to automatically…
I have two different date columns ([House Hearing Date] and [Senate Hearing Date]). I need to populate a new date in another column ([Paper Due]) that is 14 days prior to the earliest date of the two …
I have been searching the community posts for a solution, but have not been able to find one that works. I have a sheet that I need to combine multiple columns into one helper column. Here is the desc…
I have spent hours researching Smartsheet Community posts, but cannot find a solution. I have a sheet that I need to enter a value based on information in other columns on the sheet. I have tried IF,O…