bhope51’s Profile

Community member since November 2017





We are currently using a web form for customers to submit a service request. After the form has been submitted a auto-numbering confirmation is generated and the customer is sent a notification with that confirmation number. When we process the request we often need to split the service


I have purchase requests coming to me from a smartsheet form and it is capturing costs of each request. I have a "created on" column open in the sheet. I would like to sum costs of all requests per quarter. This information is being captured in a sight and broken down into quarters and Year to Date


I am looking for a way to create a static date/time when a specific action is completed in a cell. Currently we created the formula below, but we need it to return a specific static date not just todays date, which changes every day.

=IF(AND([Manager Approval]3 = 1, [Internal Processing Status]3 =