-
Need help with creating aging buckets.
Hello, I have the following formula in excel but it did not transfer to Smartsheet. Is there a way to get this formula over? =LOOKUP(F2,{-100,7,14,21,30,45,90,180},{"0-7","7-14","14-21","21-30",">30",">45",">90",">180"}) I am entering this formula in the column "Equipment Date Range" and validating the data on column "Days…
-
Cell values export from one project to another
Hello, We are currently managing a construction project with smartsheet and have created a Gantt Diagram and a few Dashboard to monitor several KPIs. The dashboards are updated automatically with every changes in the master project and provide up-to-date information during meeting. I would like to add curves to the…
-
Formula needed
Hey Please see attachment. I need help with counting the number of cells in a column, (see attachment: Column [Response Sufficient?]) that contains an exclamation mark(hold) or is blank. I basically want to count the amount of RFIs with an exclamation mark or blank cell in the [Response Sufficient?] column. I have used the…
-
Will locking a parent row lock the children?
Hello, I am looking at creating a way to track monthly time sheets. Ideally, I would like to have parent rows for each month with numbered days beneath. In theory, I would like to have an option where the supervisor approves that month, and then it automatically locks the entire month. This would mean that it would need to…
-
Automated update request not working
Hi, We are creating an automated workflow that requests an update thru a specific mail and it does not seem to work. Automated approval workflows work perfectly but update requests don't send the appropriate mail requested (eventhough in the sheet you can see that there's an update requested). Can you please help? Thanks…
-
Formula to check a box when date entered + 2 days
Does anyone know if it is possibly to set a box to check a certain amount of time after a date is imputed into a row. For instance, we need a lag time on a project complete date of 48 hours. This is for a manufacturer that needs 48 hours for stain, etc to cure before project is technically complete. This is the formula…
-
Percentage of Child Rows with Check Mark
Hi, I'm trying to get a Percentage of Child Rows with Check Mark. Can anyone help out? =COUNTIF(CHILDREN(), 1) + "" returns the count of checked boxes. =(COUNT(CHILDREN(), 0) + "" returns the count of total rows, check or unchecked. So I divided the two, but I get #INVALID OPERATION error. Any thoughts?
-
When will a "quick view" for .HEIC images be available?
Many of our team members have iPhones and the new photo format apple is pushing is .HEIC. When we upload their photos to the attachment line they are not able to be clicked on and viewed the way a JPEG is. Seeing that this a new direction in photo formatting, when can we expect a "quick view" the way we have with JPEG…
-
About the approval request for spesific people
hey everyone, i want to ask about the "approval request automation". i have project that need some approval request for the spesific people. for example, in my organization, i have 2 Divison Manager, which is a different person. so, i create the approval request by the trigger with Division 01, and Division 02. But the…
-
Log of user access to sheets
In the Control Center, I create a group of files each time a new project is started. I am being asked to create a report/sheet/dashboard that shows the date of the last time the project manager viewed/edited the sheet. If successful, this will show information on 20-25 projects, so automating the solution as much as…
