-
Copy Rows
Good day, I am experiencing this problem, i am not to sure what it means - can someone please advise me what to do?
-
How to calculate time
Hi. What's the formula to calculating time? For example, in one cell, I have my starting point of 6:00am. And in another cell, I have a finish time of 11:00am. What's the formula to calculate time between these two points? Thanks in advance.
-
Automation to "Change Cell Value" to embed a formula into the cell
Trying to set an automation to "Change Cell Value" 2 columns involved: "BARCODE" and "PACKAGE UID/LOT #" If "PACKAGE UID/LOT #" is not blank, then I don't want to override the data in the cell, however, in the absence of data in that cell ("PACKAGE UID/LOT #" is blank), then duplicate the data from "BARCODE" into "PACKAGE…
-
Automation for missed daily log
I've got a sheet that is a daily log for the check of pool chemicals. We've set up some automation to trigger if the values drop or exceed certain thresholds. However would also like to trigger a notification if the frontline staff forget to record the daily readings. I tried trigger when a date is reached (Daily) and if…
-
Symbols and percentage of
I need your help to show status as Red, Green or Yellow using this criteria: Green - 91-100 Yellow - 51 - 90 Red = 0-50
-
Is there a way to see all recipients of an alert within the automated alert email?
I have created a Smartsheet which will sent automated alerts to multiple people. Everyone getting an alert is just seeing his/her name in 'to' but not the other names. So the person does not know who is informed as well. Is there a way to change it so that every recipient sees to whom the alert has been sent?
-
Tracking that project has an update or not
I have a project tracker for my entire team with very simple information as it is a very high level overview of all active projects. My CEO will be checking the information weekly so I planned to do a Weekly Update Request that goes out to my team to 'remind' them to add any updates to their projects. Since some of these…
-
=INDEX =MATCH to pull up dates.
Hello, I've been wracking my brain trying to understand why this doesn't work. I have a sheet with some project-related data including the columns "START DATE" and "END DATE" which are date columns because they have dependencies on the duration column etc. I'm making a new sheet for resource allocation, and I need to bring…
-
Process with parent row
Hello, i have a sheet with all quoatation i sent to client and some of them moved to status "approved"/"void". the process is after i get the PO, and after i finish the job that the client buy from me i forward request to my worker for issue a invoice. i have the summary for all quotation i sent where now is it (waiting…
-
Automated workflow (email alerts) stopped working
I have a number of automated workflows set up to send alert emails that are no longer working. They were previously working fine for days (and I tested them repeatedly), but they have all of a sudden stopped. I haven't changed the automation and the sheet is locked, so no one else could have either. Is anyone else…
