I am attempting to use the nesting formulas to auto generate text showing the status of a project step that is co-dependent on several previous steps, but only when the previous steps have been select…
Hello everyone:) I currently have a sheet populated via a web form. There are several people assigned to tasks. My goal is to have an auto number column to populate a prefix & suffix, based off the pe…
I created a smart sheet that notifies the appropriate lead when someone is requesting access to a project. All the formulas, filters, and alerts are correct. The issue I'm having is when a form is fi…
Hi, I currently have the following formula which is used for counting how many jobs we intend to complete on a day: =COUNTIF({Realistic Completion Date 4}, {Realistic Completion Date 4} = TODAY()) Thi…
I would like to request that the most recent comment in the discussion function be able to be mirrored in a cell in that same row. This would allow us to quickly scan a sheet full of data and see what…
Hello all, I wanted to know is it possible for us to do find and replace in global update and change a Vlookup formula or to introduce a new Vlookup formula. I am trying to do that and i am not succes…
This would allow the user to access additional information when completing the form. I have placed a link to some information in another sheet but the link is long. I know there are applications that …
I am trying to develop a dashboard generator so that I don't have to recreate every report I use in our dashboards each time we have a new project. I would like to be able to select the project number…
Hello, for the current smartsheet, for each new/update records in smartsheet: we receive an email notification for these updates. that is great.., however, in stead of receiving an email with all the …
Hi Smartsheet Community, We're thinking of some use cases for helping Smartsheet users utilize Salesforce ServiceCloud data more effectively and efficiently. Any Salesforce ServiceCloud users out ther…