I’m simply looking to navigate around the projects I currently have, as quickly as possible, to focus on the issues I would like to address with my staff. The challenge with the reports feature is it completely removes the indenting/nesting of rows, which as a result only causes more confusion. I would like to ask if…
I am able to limit date entry to only current month and greater but I need to allow an entry of last month date upto seven days of the current month. Ultimately I want to limit the date entry into a cell to only allow a past months date seven days after the current month. I would like to use Validation for this.
I have an approval request setup in my sheet, and an age column where I am tracking the number of days since the approval request was sent out. I need a method to mark the whole project tree "Closed" if any of the children's requests for approval's "age" is over (2) days
I need to include a column that shows me the number of days that a person maintains each state (not including weekends), if you don't enter the form every day to update the information. Could someone help me with this? date of creation| Name | Status | DAYS WITH THAT STATUS 03/03/2018 | cristian | busy | 1 02/27/2018 |…
I was wondering if there was a way to create a duplicate sheet that kept the created date and created author correct on the new sheet? Right now when you duplicate a sheet, the original data gets a modified as of today, while the new sheet has all created dates and authors set to today by me.
Hi All, I have been trying to add a new task to my worksheet but can't seem to get it to work. I have tried simply copying and pasting and using the indent / outdent functions with no luck. The basic template only has a standard 3 tasks and I need a few more. Regards Andy
Within a sheet (call it "A") I used a formula referencing a different sheet (let's call it X). Later I deleted sheet "A". However I see an annoying "Used in formula from unknown sheet" in sheet X. Is there any way I can clear these out? Please help.
My company currently uses Device Magic Forms to do daily reports for people to communicate from the field to the office. We then have to take what's on those forms & re-input that information into Smartsheet to track our projects. This is a time suck on our company, so we are trying to directly have all of this on…
Building an employee hiring database (sheet 2) off our hired applicants sheet (Sheet 1). After typing an email address in the first column of the sheet 2 , it should populate 4 or 5 subsequent columns across the same row in sheet 2. The column information and email address are both included in sheet 1. I have tried many…
Someone knows how to include weekends in a single row on one sheet and that all other rows include only work days? Thanks!