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 Everyone, thanks as always for your help! I have a quick question on the best way to apply default values when adding a new row to a grid view. The idea is that if someone enters a new task name, t…
Hello! So - I am working on building dashboards for my company where we can track To Dos. goals, etc. I have made reports, added them to the dashboards, and connected the report widget back to the dat…
In the Project Management Learning Path via Smartsheet University, I'm running into an issue where it will not allow me to run the 'Regular Task Update Request' weekly on Monday, Wednesday, and Friday…
