-
how do you copy an old smartsheet
We track Time and Effort on Smartsheets. Once the form is filled out we need the Smartsheet to move on to the approver. Nothing is working like it did last year.
-
How to find a missing contact
I have a multi-contact column where I assign users to a task [Assigned To]. I have another column where one of the assigned users selects their contact once they have completed their portion of the task [Completed By]. I want an automation that sends a reminder/Update request to Assigned Users that have not Completed their…
-
Formula to tick a box if two conditions in another sheet are true.
Hi, I am trying to use a formula to tick a box in Sheet 1 if the following conditions are true: The email at row (Text Contact) in Sheet 1 matches the Email in the deployment sheet (Email Deployment) and the Event in the deployment sheet (Event Deployment) is equal to "Event Name". The event column in the deployment sheet…
-
how to make a sum for each day automatically ?
as you can see in the picture bellow, I want to make a function to generate an auto sum for each day where any time day changes, I get the sum directly of the same day. P.S: numbers in DailySum are random and for AmountIQD it has this function =[مجموع الاليات]@row + [مجموع العمالة]@row + [مجموع المواد]@row your help is…
-
Military Time
I have a column that the time input is in 24 hour time, but my staff will use 0700 instead of 07:00. Can I create a formula that will change 0700 to 07:00?
-
Can I use the formula COUNTIF to give me the number of hires by week?
Hi, I have my COUNTIF formula started to show the total number of hires in each category type however I need to further break it down by week. Ideally showing the number of hires within the next 7 days per category. I am feeding this sheet into a metric widget on a dashboard for others to view and would like to not have to…
-
"Last Update" to look for last manual update, not last formula update
I currently have a column that counts how many days until the due date. Because this column formula utilizes "TODAY()", this means the column re-calculates every single day. Because of this, my "Last Updated" auto-fill column always lists today (or the last day I opened the sheet) as the time the rows were last updated. Is…
-
Calculate duration between two times
Im looking for a formula to calculate difference between two times eg 08:00 - 10:00 should give a duration of 2 but running into errors. I have column types as text number. 08:00 is named Start Time and column for 10:00 is finish time
-
basic formula im sure, but Im new to this
I am trying to write a formula that says the if the end date is before today that it selects the "Late" option out of the drop down in Status. I got most of the way there but keep getting an error. HELP
-
Formula to sum children rows into parent row
Hi Is there a formula to add up total hours for children into Parent row cell? Also to add earliest local start time and earliest local finish time in parent header?