Formulas and Functions

Let the community help you with that tricky formula or function! See how others are utilizing the power of formulas and functions to save them time and create more powerful solutions with Smartsheet.

Discussion List

  • Summing fields in a web form
    In Formulas and Functions
    I have built a purchase request form to replace a PDF and allow the users to enter details by department and upload attachments. One thing I would like to be able to do is to have the form sum up while being entered - item price + Tax + sh…
    Accepted
    14 3
    Accepted Answer 14 views 3 comments Most recent by Andrée Starå
  • I need help for creating formula for automatic checkbox
    In Formulas and Functions
    Hi everyone I need to create formula which works as follow. If I put any date in column Completion date then checkbox Done will be in status checked automatically (Image)
    Accepted
    54 5
    Accepted Answer 54 views 5 comments Most recent by Andrée Starå
  • Need help with a VLOOKUP and MATCH formula
    In Formulas and Functions
    Hi there, I confess I get so lost when it comes to formulas. I've read through various community discussions and help pages, but for some reason I just cannot get the logic of creating a formula. In sheet 1 I have a column for "Freela…
    Answered - Pending Review
    14 6
    Answered - Pending Review 14 views 6 comments Most recent by Andrée Starå
  • Return Data based on two conditions being met
    In Formulas and Functions
    Hi, Please can you assist with a formula that checks data from two cells within a sheet that will then populate a matrix sheet. The data sheet is being populated via form currently. If Property Name is "Mykonos" and if Quarter 2…
    Answered - Pending Review
    5 3
    Answered - Pending Review 5 views 3 comments Most recent by Andrée Starå
  • Update Status and Progress of an activity based on Actual Start and End Date
    In Formulas and Functions
    Hi , I am relatively new to smart-sheet and would require assistance in setting up formulas for my POW Sheet .I would like to have my status column of an activity to be updated based on the actual start and End Date Start Date = Blank S…
    Answered - Pending Review
    17 5
    Answered - Pending Review 17 views 5 comments Most recent by Jameel Nahas
  • Automated Workflow Notifications
    In Formulas and Functions
    Hi everyone, I've created a sheet with multiple points to send a notification based on the date. Several columns are irrelevant to our work and are used simply to send a notification (i.e, if a checkbox is marked because month date and ye…
    Answered - Pending Review
    8 3
    Answered - Pending Review 8 views 3 comments Most recent by Andrée Starå
  • Referencing an entire column from another sheet
    In Formulas and Functions
    Hello, I am working on a cross-sheet formula. The ultimate goal is to write something that says this: If room column on [Sheet 2] contains "room name" AND (date on [Sheet 1] falls between Check in Date and Check Out Date on [She…
    Answered - Pending Review
    14 1
    Answered - Pending Review 14 views 1 comment Most recent by Genevieve P
  • Sheet Summary when Request Owners Varies
    In Formulas and Functions
    Hello, I am trying to add a count of Request Owners to a dashboard. The Owner varies and I have not figured out a way to have new Owners appear. How do I include them on specific Owner Count on my dashboard. Is this possible? Thanks
    Answered - Pending Review
    13 3
    Answered - Pending Review 13 views 3 comments Most recent by Andrée Starå
  • Formula autofill to the next rows in a sheet when using hierarchies
    In Formulas and Functions
    Has anyone had any success with maneuvering around the fact that new parent rows created by a form and added to the bottom of a sheet will not inherit the formulas of the row above? Here's the note from the Smartsheet help: NOTE: Form sub…
    Answered - Pending Review
    85 5
    Answered - Pending Review 85 views 5 comments Most recent by Andrée Starå
  • How to use Form response to retrieve the right template?
    In Formulas and Functions
    I have 7 templates for client renewal. I want to create a workflow either with a form or formulas, the user will select the right template for the client renewal and automatically added to the Master Client Renewal Project Plan. Example 1…
    Answered - Pending Review
    10 1
    Answered - Pending Review 10 views 1 comment Most recent by Andrée Starå