-
Can you Log a Cell In time?
Within my project sheet I have formulas set up to show me the present of Target duration vs actual completion date. The parentage in cell will change as we close out projects. Is there a way to track/Log this cell as it changes so that I can create a line graph to see our patterns over time?
-
Request an Approval now has the sheet link, why?
Does anyone know how to remove the sheet link option at the bottom of the approval workflow? When was this added, and why? This workflow should be treated the same as the Request an update, where it doesn't give the option to the approver to access the sheet. OR If approvers need more information than what would…
-
Automation - Workflow - Reminders when a date is reached
Hi, I created the below workflow to alert me 1 week before my due date column for a project I am working on smartsheet. I am not receiving any email alerts - I did check and I have all notifications allowed under my account so that is all good. Have I not set this up correctly maybe? Does it look okay or do I need to…
-
Checkbox find duplicate in a column, do not check either box if either has a value in 2nd column
I am using a checkbox to find duplicate entries in the column name Email. I can up with this that worked, =IF(COUNTIF(Email:Email, Email@row) > 1, 1). Next, I am looking for both duplicates to not have a value in the Using Generic Account field and then check both boxes. Do not check either box if one of the two…
-
Input/auto fill data from different rows
Hello, Please find the example photo I would like if there is a formula that can auto fill and input data in blank columns/same row once i type the phone number (in column phone) by calling or looking up for the data from other rows in same sheet (or from other data pase sheet) taht engaged with same phone number. For…
-
Why is my automation not triggering?
I have two columns I would like to run in an automation, one contains a check box and the other contains a drop-down menu of text values. I am trying to run an automation in which when I check a checkbox in one cell, it updates the "Status" cell in the same row to 'Complete'. The automation either doesn't trigger or takes…
-
Datamesh very slow to update
Hi, we have datamesh set to immediate but it still takes up to a minute for the data to be pulled into the sheet. Is this the normal amount of time it's supposed to take? Or have I missed a trick?
-
Allowing Multiple Smartsheets to be published to One Google Calendar
I would love to be able to publish several of my smartsheets to one google calendar so everything is in one place. Please let me know when this feature maybe added! Thanks
-
Automated Email 2 days after a date if no attachment
Hi There, I have a fair bit of automation setup in my workspace for all the relevant rollout / install sheets to do multiple things including: Send reminders 1 and 3 days prior to ensure the store/retailer is aware and the space is clear Reminder on day of install at 5pm to ensure an attachment of the evidence of install…
-
Need to identify who responded in the survey
I have two sheets. Sheet A is the master list of the names while Sheet B is the list of the respondents of the survey form both containing the unique identifier code. I need to identify who has and has not yet responded to the Smartsheet form. Questions: Is there a way to automatically mark Sheet A when a person submits…