Formulas

Discussion List

  • IF FORMULA
    In Archived 2016 Posts
    Hello there! I'm new to Smartsheet and I haven't found an answer to my question yet. I would like to make a symbol appear if a set of cells are not empty. In a few words, if cell A, B, C are not empty then I will have a green ball on cell …
    41 1
    Closed 41 views 1 comment Most recent by Heidi Decker Archived 2016 Posts
  • Checking checklists
    In Archived 2016 Posts
    Hi all,   I have a series of columns with checklists that I need to analyse and need some help, please.    The logic is this: if the report is "completed", but _any_ of the several asset check cells are still not checked, a c…
    12 3
    Closed 12 views 3 comments Most recent by J. Craig Williams Archived 2016 Posts
  • Report on today and next workday
    In Archived 2016 Posts
    I'd like a Report that shows rows with the Date field from today or the next workday.   That is on   Monday - shows Monday/Tuesday Tuesday - shows Tuesday/Wednesday ... Friday - shows Friday/Monday Saturday - shows Saturday/Monday …
    301 8
    Closed 301 views 8 comments Most recent by J. Craig Williams Archived 2016 Posts
  • Formula help - set values for current user and date when check box checked
    In Archived 2016 Posts
    I have a checklist I am building for a department where they will be primarily mobile users so I would like to reduce the thumb typing as much as possible.   I see where I can use test the value of a checkbox and make it do things.. but …
    MP Profile Photo MP
    357 5
    Closed 357 views 5 comments Most recent by J. Craig Williams Archived 2016 Posts
  • IF THIS AND THIS then TRUE CHECKBOX
    In Archived 2016 Posts
    Since Smartsheets currently doesn't have timestamping system I am using manual dates to do so however I need a checkbox to be ticked to alert me when two conditions have been met. These conditions are dates and are blank before data goes i…
    2626 6
    Closed 2.6K views 6 comments Most recent by John Sauber Archived 2016 Posts
  • If Statement & Dropdown List
    In Archived 2016 Posts
    I have a dropdown list with 5 values and inserted an IF statement into the cells for that column to auto-fill 1 of the 5 values. I noticed when doing this you can no longer access the drop down list. Is there a way to auto-fill so the cell…
    478 1
    Closed 478 views 1 comment Most recent by Atus Bartal Archived 2016 Posts
  • Date Formulas
    In Archived 2016 Posts
    I need to keep track of the day an item is approved. Is there a formula that I can use to generate a date that a check box is checked off??   Tiare
    1 1
    Closed 1 view 1 comment Most recent by Brett Evans Archived 2016 Posts
  • Sending notifications to a specific user for any row changes
    In Archived 2016 Posts
    Hi,   I want to send email/mobile notifications to only the "Assigned To" person when anything (including attachments/discussions) changes for that particular row. Please think of this scenario where a particular task is assign…
    2 3
    Closed 2 views 3 comments Most recent by Gwyneth C Archived 2016 Posts
  • Stringing Logical Arguments
    In Archived 2016 Posts
    Hello,   I have been struggling with this formula for a few days now and can only get bits and pieces of it to work. So I am hoping I can get some help here. Essentially I am trying to create a formula that includes 5 fields and dependin…
    22 3
    Closed 22 views 3 comments Most recent by Shawn R Archived 2016 Posts
  • Create percentage complete based of boxes checked
    In Archived 2016 Posts
    Hello,   I am very new to smartsheet and still quite inept.   I have a smartsheet that I am using to track a student I am mentoring.   There is a coumn titled 'Completed'.  This allows the student to check when a specific task is com…
    1153 4
    Closed 1.2K views 4 comments Most recent by Luis Vega Archived 2016 Posts