Formulas
Discussion List
- I've been working around collecting data from multiple sheets with help from this community, and I've run into another snag. I'm trying to pull data from a referenced column with a matching location n…
- The question seems simpler than the outcome I'm hoping for. I need to combine distinct project types from multiple columns on multiple sheets. I know I need to use Join, Collect, Distinct, and potenti…
- Hi All, I am trying to add a Follow Up Date to my sheet, following a Submission Date. I tried: =[Submission Date]@row + 14 and instead of getting a date 14 days in the future, I am just getting the nu…
- I have an intake sheet where one of the fields is a multi-select drop down list. The values in the list are NUMBERS; TEST NAME. I want to be able to parse out just the number into a separate column in…
- Hello - I would like to use a VLookup formula to pull dates into a column of a sheet I'm working on. The scenario: Column 2 needs to pull in a date from the reference sheet for the same company of the…
- I need a formula that will auto populate the status of a parent task based on its children's statuses. If all children have the status "Not Started", the parent should reflect "Not Started". If any ch…
- Hi, I am trying to count both "YES READY" and "YES READY NO SHIELDS DUE TO CREDIT HOLDS" in a Summary Formula. This is a drop-down in a column and I am trying to include both in a summary formula.
- I am looking at making our internal quote system entirely through smartsheet. Is there a way in which i can expand a row in order to make relatively complex quoting system which almost acts as a mini …
- I want my user to enter the Completed date and the Check box in the Completed column gets checked. I know this is simple, and I have found answers for the other way, but I want it set this way.
- Hi, I have a cell@row value in the column Zone1 separated by a delimiter which needs to be split into different rows as a list of values similar to column Zone1new. Could i get help on this?