-
Auto fill column?
Hi, everyone. I don't know if this is a possibility or not but I'm hoping someone can help. I'm looking to see if it's possible to set a formula/equation/conditional formatting so that what's entered in one column will autofill another. Example: I have a column called Access Requested (dropdown) and another called Type of…
-
Start & Finish dates based on separate predecessors / or formula in duration
I am trying to automate my schedule for a project as much as possible. I have a line for production start that is based on my current ship date but I have 9 shipments after that and would like to have the actual production line have a start day based on the production start line and the finish date be the last ship date.…
-
How to I "not format" a number in a form?
One of the questions on my form is what year(s) someone attended our annual meeting. The format is text/number. if someone attended in 2016, 2017, and 2018, the answer is being formatting with commas and displays as 201,620,172,018 even though I typed it as 2016, 2017, 2018. The only way around it is to direct people to…
-
How do I use a countif formula to count the number of various priorities?
I have a column for priority which returns symbols. Exclamation = high, dash = medium, and down arrow = low. I have tried various formulas and nothing is working. I basically want to know the amount of highs, mediums, and lows in my sheet. Help please! Thanks, Dacey
-
Linking smartsheet
I have a master sheet that I am using to pull in data from the child sheets (linking). The child sheets are dynamic and new parents and childs could be added. 1. When linking i lose child sheet hierarchy on the master sheet. How do i maintain hierarchy? 2. When new tasks are added (with hierarchy) how can i keep the master…
-
Score Formula
I've created a scorecard in smartsheet and want to create a formula that does not allow the scorecard score to show as more than 100%. I think is should be something like If score >100%,100% but am not sure what the entire formula should be.
-
Formula to calculate the Next [Future] date in a string of dates
Hello, I'm looking for a way to find the next task due date. Ideally, I'll be able to look at a row with several date columns, and determine the next date. This would be the MIN Date that is Greater than Today's date. I can easily get the MIN Date, However, many columns are in the past. I want the next [future] date after…
-
COUNTIFS for 2 and 3 criterion
Hello, I am trying to have my formula count when the row has "Ken Mallory" for the name column and any date that equals January. This is what I have so far but it is Unparseable. Thanks for your help:) =COUNTIFS({Master Compliance Sheet Final ver 1.0 - 12 Range 2}, "Ken Mallory", {Master Compliance Sheet Final ver 1.0 - 12…
-
VLOOKUP for attachment on another sheet
Smart sheet enables the user to upload attachments, which is useful. So what I do for my workflow is I have a full sheet dedicated for part number and part information, so when I type in a part number on the work order sheet it auto-fills the rest of the information such as description, assigned person etc using the…
-
Value function
Having trouble with the formula below. Version 1 works and extracts what I need from a cell. I need to then convert that to a numeric value. Currently I get #invalid value. I'm missing something, and I bet it's dumb. ;) * =MID([Active Link]@row, (FIND("/", [Active Link]@row) + 1), ((FIND("*", [Active Link]@row) - 1) -…