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 c…
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" …
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 …
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 mo…
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 …
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 …
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 Sma…
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…
Hi all, Longtime reader, first-time poster...having a struggle day with the brain and some trouble with a nested if shooting back the INCORRECT ARGUMENT error. Trying to code a 5-Part Progress Bar col…