Cell linking

 

Discussion List

  • Is it possible to count the number of entries in a column for the current work week, and quarter?
    In Formulas and Functions
    Is it possible to count the number of badge IDs in a column for the current work week, and a quarter? I need to track the progress of a weekly target that resets every Friday. Currently, I can not get the CWs (blue) to align this is my sta…
    Answered - Pending Review
    42 4
    Answered - Pending Review 42 views 4 comments Most recent by Adriane Price Formulas and Functions
  • Include child rows in approval request
    In Using Smartsheet
    Hi all, I'm hoping that you can help me find an easy solution to an issue I'm facing. I publish two monthly newsletters (External and Internal editions in the screenshot below) and the first step of my prep work is to have my manager appr…
    Accepted
    16 3
    Answered ✓ 16 views 3 comments Most recent by Tiffany McKerahan Using Smartsheet
  • CountIF / IsDate combination
    In Formulas and Functions
    Hello I am trying to link formulas to count from a list or column all the cells that contain date and discard that which are text. But I can not get the combination of the formulas to work well. Thank you in advance.
    140 9
    140 views 9 comments Most recent by Paul Newcome Formulas and Functions
  • Rich Formatting On "Summary Sheet"
    In Formulas and Functions
    I'm stuck! I am effectively trying to create a Sheet Summary report with conditional formatting, however, I understand that is not an available feature. Instead, I am trying to create a sheet (not a report) with formulas that pull from mul…
    Answered - Pending Review
    19 3
    Answered - Pending Review 19 views 3 comments Most recent by Tamara Moore Formulas and Functions
  • IF Formula with Children
    In Formulas and Functions
    Hello Everyone, I am trying to figure out a formula that would show the children's status on the parent row. IF the children's "Status" column is "Completed" OR "Completed By Black Ops", the parent "Case …
    Answered - Pending Review
    11 1
    Answered - Pending Review 11 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • CONTAINS with Trigger Search
    In Formulas and Functions
    Hi all, Thank you in advance for the help. Below is what I am trying to achieve. The columns are as follows: Address and Device Type Explanation: When Device Type contains the word "Coin". This will use the address of the device …
    Answered - Pending Review
    28 6
    Answered - Pending Review 28 views 6 comments Most recent by Paul Newcome Formulas and Functions
  • Looking for most recent date
    In Formulas and Functions
    I have two sheets. The first is a tracker for up coming reoccurring tasks and the second is a copy of rows that have been completed. In the first sheet I would like to collect the date from the "date" column in the second sheet …
    Accepted
    777 9
    Answered ✓ 777 views 9 comments Most recent by Genevieve P. Formulas and Functions
  • Populating a Dropdown List
    In API & Developers
    Hi, is it possible to populate the contents of a dropdown list from another smartsheet?
    8765 21
    8.8K views 21 comments Most recent by Pam Ferguson API & Developers
  • Numerical "Priority" Method
    In Formulas and Functions
    Hello, I am in need of a method for assigning priority of a submitted row 1-10. If 1 is selected, the previous 1 needs to become a 2, the 2 becomes a 3, etc. The column needs to recalculate when a row is complete and the 'priority' column …
    Accepted
    11 3
    Answered ✓ 11 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Auto populate data in Forms
    In Using Smartsheet
    I am trying to auto populate the data in Forms for example if we select ID the corresponding fields will get auto populated with required values. As per the attachment if we enter any ID in the CUS ID field it should populate the PSS Firs…
    3449 16
    3.4K views 16 comments Most recent by IanM Using Smartsheet