We have been using SmartSheet for about 3 years and have recently developed an approach for our project managers using SmartSheet. We are about to roll it out to our staff but have found an intermitte…
Let's see if I can properly explain my question! I'm using the Meeting Agenda template to create and track agenda items. I'm then using that sheet to add notes to each agenda item during the meeting. …
Hi all, Relatively new to Smartsheets and I am looking for a bit of guidance here. I am trying to put together a 'Resource Forecasting Tool' for our company, wherein the users can populate either an '…
Is it possible to create a project plan in Grid View and have it seamlessly transfer to the Kanban board on Card View? The hierarchy on the Grid View impacts the display of cards on card view. See att…
I have a issue that I just can't figure out. I have 2 identical Smartsheets one was saved as new from the other. I have the same formula in the same column in the 1 Smartsheet example I get a #INVALID…
I'm trying to write a formula using an IF/OR statement to set a flag (for the Revised Timeline column) when NA has been selected from a drop-down menu in the any one of five columns (e.g., Reason for …
Hi Community - Looking to crowdsource the best method of creating a Master Sheet (think: Company ALL) composed of smaller Department Sheets (think: Marketing, Development, etc). The ideal set up here …
Hi all - First Discussion here. I am trying to use a formula that will populate a cell with "Not Started", "In Progress" or "Completed" based on the condition of eight cells in the same row have data …
I would like to build a formula so that status will change to "Red" and type will change to "Renew" when date is past "Expire Date". I've applied the two formulas separately at the top of each corresp…
I'm trying to recreate a switch function I've used in Project files to work in Smartsheet. It updates a symbol status column based on %Complete, Today's date, and Finish dates. I'm trying to use the g…
