For each month, I am trying to sum up data depending on the type of project it is. For example, "If the 'Project Type' is 'Strategic', this is the total hours for the month of February," "If the 'Proj…
Hi, is it possible to set an automation to run 24 hours after the field is changes instead of once daily? I want to give the person a 24 window to change the option picked. Thank you
Hello! I'm trying to work out an automated notification that is triggered weekly. We have a date field that will house a calculated date based on another field. We want a contact field to be notified …
Hi, my goal was to copy from excel to a sheet, but that is not working for me, so I decided to try the copy to another sheet automation. I would like to import new data from excel into a sheet and hav…
Hello Team, I was trying to setup automatic replies to people who enter their email and select a certain timeframe. I would then like to send an automatic reply with information regarding the session …
I'm currently having trouble figuring out how to capture the number of status specific projects assigned to an individual. I've attempted the "COUNTIFS" formula many times, but can't seem to configure…
I have a few questions regarding forms. The form I'm setting up has a field for Email Address and if the user wants a copy of their responses, they're required to enter it again at the bottom. I tried…
I want to be able to have two sheets with two different forms, but then I want the two forms to also have one sheet with the answers from both forms so that the answers are combined. Is that possible?…
Hello, Is it possible to use Smartsheet to automatically create a single row report and mail a viewable link? Use Case is similar to getting a package tracking number where the end user can view realt…
I have automations setup to copy completed tasks to a separate sheet. When the sheet fills up and can not accept more data i received a notification that these automations cant run. So i went into the…