I have a project management sheet with roughly 800 rows. I have one column called "phase" which tells folks who work on multiple project types, the project phase of the project for their reports (Lead…
Hello experts, I know this question has been asked before. But I have been trying for a while, and I can't figure out what I am doing wrong. I Need to create an IF formula with 2 criteria. If my targe…
Hello, Currently attachment is allowing either to attach a URL or upload a file or different file versions. But for editing, the user cannot edit online and it only allows to download the file and upl…
Hello, Is it possible to arrange a meeting from within SmartSheet - instead of using Outlook. That way one could send a meeting invitation where the SmartSheet document would be an attachment similar …
Hello, I would like to know if there is a way to force a task to be planned a particular day of week (sunday in my case) ? Saturday and sunday are not working days but for special IT operations we nee…
Hi, When i'm input the date @ "Done_DP", "Down Payment" became green, how to setup a formula to auto remove "Due Date 1"'s content or change to DONE (Due Date 1 are drop down list with "DONE") Thanks …
Hi! I have 7 columns that have check boxes. When all 7 columns in one row are all checked, I would like a column that will auto populate a "completed" date. Is this even possible or am I insane? haha!…
Good afternoon everyone, I am having a heck of a time trying to figure out why my formula keeps returning as #unparseable. If a Category says Expedite, the cell needs to show $25.00, if not, it needs …
Hi All, we often have changing allocations for team members on a given task - ie no a flat 50% allocation for one task across multiple days. For instance - that person's allocation may be 25% the firs…
Hi! I'm really enjoying Smartsheet and glad we decided to go down the path of subscribing. While I was getting certified I found so many neat features and my mind just filled with all the things I cou…
Hi Smartsheet superusers! Ok, so I used Smartsheet with a previous employer for a few years and it's been about two years since I was really working in the system. My potential new employer uses it an…
I have data on a "copy of construction checklist" that has been shared to me. I am an admin to the shared copy of construction checklist. If the owner of the sheet, cycles data off the sheet due to co…