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…
Hello All, I have a manufacturing schedule sheet which lists tasks that are sorted by date. I have a bunch of conditional formatting rules applied to make things easier to read and identify. Each day …
It seems as though the wrap feature is not working on the latest comment column. Trying to utilize this in a weekly WIP report and need the text to wrap to see the comment. See attached. I have 2 othe…