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 FunctionsIs 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 views 4 comments 0 points Most recent by Adriane Price Formulas and Functions
-
Include child rows in approval requestIn Using SmartsheetHi 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…
-
CountIF / IsDate combinationIn Formulas and FunctionsHello 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.
-
Rich Formatting On "Summary Sheet"In Formulas and FunctionsI'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 views 3 comments 0 points Most recent by Tamara Moore Formulas and Functions
-
IF Formula with ChildrenIn Formulas and FunctionsHello 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 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
CONTAINS with Trigger SearchIn Formulas and FunctionsHi 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 views 6 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Looking for most recent dateIn Formulas and FunctionsI 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 …
-
Populating a Dropdown ListIn API & DevelopersHi, is it possible to populate the contents of a dropdown list from another smartsheet?
-
Numerical "Priority" MethodIn Formulas and FunctionsHello, 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 …
-
Auto populate data in FormsIn Using SmartsheetI 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…