-
VLOOKUP plus a Dropdown selection???
I don't think this is possible, but thought I'd ask here. I have a situation where I would like to look up a value in another worksheet if the the value in a column adjacent to the lookup contains "DMP". I know how to write that formula, but if the value does not contain DMP, then I don't want the lookup at all, but want…
-
If 'Submit Date' is before the 20th of current month, Set 'Payment Due' to last day of month
Hello! Creating a sheet to help with Accounts Payable process to external providers. External providers will submit their invoice and payment details into a form that feeds into this sheet. Would like the formula to determine when that invoice is set to be paid, depending on the submission date. The formula in words.. If…
-
Equation help
Hi all, I'm not very privy with formulas, but am attempting to learn. I'm working on keeping track of square footage production based on "in progress" or "completed" in a manufacturing setting. There are 6 different steps to each unit produced (on different lines, see screen shot), and I'm trying to figure out a way to…
-
How to use INDEX, MATCH and MAX to display newest form entry if cells match
Here's the setup Sheet 1 Columns: Created [standard] | Name | Form Entry Sheet 2 Columns: Name | Form Entry Display MATCH Name:Name and take the Form Entry with the most recent Created i.e. the newest entry Ideas?
-
Forumula for trending up/down
Hello, I need a formula to display the trend of a number. As rows (data) comes in the average value of the column changes and as time goes by the values will go down. I need to compare that average value each day. Meaning if today's average is 5.10 and tomorrows average is 5.50, I need to compare those two numbers to…
-
How to ignore, or return a 0 with a blank cell in an IF formula
Hello! I'm trying to calculate my savings year-to-date. I thought i had the formula, but soon realized that having blank dates (maybe we don't have a start selling date, or the project is still in development), it'll still return a value when it should really be $0. I have no doubt there is a more elegant way to do my…
-
Tracking rows from other sheets
Hi everybody I have several rows from different sheets that feed my master sheet via "move row" automation. I need to track in a column on my master sheet which row is coming from which sheet. The only approach I can think of is adding a column on each sheet with its name so when the row is moved, it is added to the master…
-
What is the effective approach to Group Management and Contacts
i would like to have a contact with name. I need Groups so have to add contacts via Group Management else it won't allow me to add a contact from "My Smartsheet Contacts" Within Groups, I can either paste all emails or add one by one. The former will not allow names to be added, the latter is manual and painstaking if I…
-
Counting multi select column that is also contact list
I have Contact list - multiple resources can be assigned task I want to count the number of times a particular resource has been assigned a task. I've tried these both: =COUNTIF({Staff Actions Range 4}, HAS("Joe X", {Staff Actions Range 4})) =COUNTIF({Staff Actions Range 4}, CONTAINS("Joe X", {Staff Actions Range 4})) Both…
-
Smartsheet for Pandemic Readiness- Dont Panic Prepare!
IT departments must take the lead on pandemic response planning... Your Challenge COVID-19 still has a lot of unknowns. Despite efforts by international and regional health authorities, misinformation and misinterpretation of available information are complicating the situation as individuals and organizations seek to…
