Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Web Form - Signed
HI all I am creating an onboarding web form however we need the form to have the ability to be signed, I know SmartSheet has an app with Docusign but this is very expensive Does anyone have any tricks or ideas of how this could be done Thank in Advance
AVG() returning divide by zero
Hello, I am trying I receive help with making a formula that will take the average of the children rows. I found a VERY similar post, and tried to use that formula, but it did not work. The problem is that I have tried to take the average of the children rows, and display it in the Parent roll. The average is of…
Can I add a formula to a drop down list cell?
I currently have drop down list that contains, "Not Started", "In Progress", and "Complete". What I would like to do is add a formula that automatically changes the drop down list from "Not Started" to "In Progress" if the Duration cell has been changed from 0% to anything non-zero. Is it possible to add a formula to a…
Newest date in children input text
Hi everyone Is it possible to automatically input data from all children regarding newest date to parent? For example I have 10 children, with text and multiple dates in the same children row, I want it to automatically upon newest date in specified collumn in all children input the text in the text collumn from that…
Can smartsheet do this
I'm new here but have watched multiple webinars and read the getting started info. Before I invest a lot of time in this, I'm wondering if smartsheet has the ability to link two sheets with a one-to-many relationship. For my purposes, I'd like to have one sheet of open orders and another sheet of lineitems. There can be…
Creating and editing schedules in Calendar View
Hi all, I am just wondering if there is a way to visually create and edit a schedule in Calendar view. Such as dragging dates and durations like we do with Gantt bars? Darin Schnitzer
Outlook
Hi, I am trying to use your smartsheet addin for outlook. I have a MS 365 account. When I try to send the email via the smartsheet tick in outlook, it redirects me to the following...see attached. Can you please advise Regards Steve
Indent/Outdent
I have over a years worth of indented drop down list worth of info and randomly one day all of the indent buttons disappeared and i cannot open any of the indented drop down lists unless i randomly search something in that list. It wont let me reapply the indent/outdent option either. What do i do?
Email Alerts Triggered From Text Column?
Is there a way to set up a sheet alert to send me an email 3 workdays after text is added to a specific column?
Formulas
I have a drop down text for my second column, I would like to insert a formula that when shipped is selected from the drop down, that it auto checks the check box in column 4 for complete. I have looked through all formula help sheets and can't seem to find this one. Is this even possible? If no, does anyone have any ideas?
