I have a duration in days column and I need to show what that duration is in months, weeks and days. Assuming a month is 30 days and a week is 7 days. The attached blue columns are what I want to calc…
Hi all! I'm working on adding a formula to a column to populate status symbols in another column. I've attached an image of the sheet for clarity - I would like to display the symbols in the 'Director…
It would be cool if instead of going from form to sheet it could go from sheet to form. I send out a lot of paperwork that if I could just populate with the info from certain columns, it would save me…
I have multiple Smartsheets this has happened to, although I save and make sure prior to closing the SS it has been saved, and triple-check by the "save" icon being "shaded" prior to closing the SS. F…
I'm trying to develop a formula for the Booked column that will return true if the value in Date/Time is found in another sheet. That much I can do, but my problem is that the timeslots are 4 hours lo…
My team and I are adding rows to a sheet. I want to be able to sort the rows of information based on the date the rows were added. As a result, I sorted the rows according to the date they were create…
I know that some of this can be achieved with linking and some manipulative formula but I think it would be great (at least for me ;-)) if there was the ability to change the content of a cell on one …
I want to extract both the 1234 and 4567 from this text string: "First set of data to extract between parentheses (1234) and second set of data to extract between parentheses (4567) and that is it" I …