-
Return a value based on 2 matching criteria, one of which is a dropdown menu.
I am working on a formula that will match a date from my reference sheet to my working sheet, and a word from a dropdown menu in a reference sheet and return the word "Completed". None of these work
-
Date Function Returning #INVALID COLUMN VALUE - even in clean new sheets
Hi all. I’m running into an issue that I can’t seem to resolve, even after a lot of testing. Hoping someone here might be able to help. Basically, any formula I use that involves a date function, like ISDATE() or TODAY(), is returning #INVALID COLUMN VALUE — even in completely new, empty sheets. Here’s what I’ve tested so…
-
Issues with Attachments
Ok, I'm not new to Smartsheet but recently this simple automation has had me stumped. Pictured below is a simple automation we use to verify that an attachment has been added to each row in our system. IF attachment added or changed, THEN Change Cell Value. These worked beautifully all over our system until about a month…
-
Formula Help - Phase identifying
Good morning :) I'm trying to figure a way that the row is labeled by the phase of the project that the line is in without having to manually do it. Please see below expected output for 2 phases. I have also attached an excel sheet. I would greatly appreciate any help on this please.…
-
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.
-
Calculate Project Time TOTAL for PM across aligned projects
Hi - I am trying to figure out how to create a SUM of the Total Project Time aligned to each PM for all of their projects. On my master sheet I have the Resource Type, Resource Name, and a Helper Column for Time. The Helper Time is an estimated allotted time based on the timeframe of the project. Example: <3 months = 25…
-
Match or Index
I am trying to pull a phone number and email from our master roster that is on another sheet in Smartsheet. I cannot figure out the formula. This is the formula I have tried. =INDEX([EMPLOYEE NAME]@row , MATCH({IMS Master Roster Range 2}), 0)
-
Calculate number of days between two dates in the same column on the same sheet
Hello, Can a combination of the INDEX(COLLECT and NETDAYS Formula be used to get the number of days between two dates in the same column? I want to get the number of days between two dates on the same sheet, in the same column, that have matching names and different project types. For Example: Studio Name is equal to…
-
Countif, index/match
I'm working on a formula that will return a count based on a matching dates and the word "Quality", but I'm getting the unparseable error. I'm sure it has to do with where I'm putting the ) and ,0 ,1. Here are some that I have tried:
-
Using lookup formulas with Contact Cells
Hello, Trying to sort through an issue I have been having. I am trying to lookup contacts on one sheet against a source sheet to see if they are present. The sheet I am using has the contact in a contact column, but only as an e-mail with no name associated. The source sheet has BOTH the contacts e-mail and name, but by…