-
Auto-fill is just plain broken - or just so dumb it seems broken
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 (Leads, Pre-Development, Development, Checklist). On my column for phase I set the first row to be "Development" for the phase. I…
-
If/And formula
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 target date is empty and it is greater than today, then don't do anything, if not return a 1. attached you will see a print…
-
Edit attachment from a sheet
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 upload it again. Do you know if there is a plan in Smartsheet roadmap to enable a functionality for editing existing…
-
Arrange meetings from within SmartSheet
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 to Outlook process. Thanks, Sigurdur
-
Sunday IT operations
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 need to work a day off. Thanks for your replies.
-
Auto remove or change content.
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 in advance.
-
Check boxes to equal complete date
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! Thank you!
-
IF Formula returning as Unparseable
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 to show $0.00. My formula is =IF(Category1 "Expedite", $25.00, $0.00). I've tried removing the dollar signs, the decimals,…
-
Resource contouring -> variable allocation per day or week on a single task
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 first day 50% the 2nd and third, 100% the 4th and 25% on the last day of the task. This is known as resource contouring in MS…
-
Tracking Data / Shared Sheet
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 could probably use various aspects of Smartsheet to accomplish. I ran into a limitation in my own scope that I'm sure…
