-
YEAR Function to look at multiple columns to pull year from
Is there a way to have a formula using the YEAR function to look at multiple columns until it comes to one that isn't blank? I'm attempting to pull the Year from various project start date columns. Some lines will not have dates in a column. i basically want the formula to look in each of the columns listed below (startโฆ
-
Entering Pictures from Phone/Tablet into contact card
I created a contact card to help populate a sheet. Why when filling out the sheet it does not allow me to take a picture from my phone/tablet to store in the filed. I can take a picture if I have the sheet open with Smartsheet but I really want to use the contact card to fill this all in.
-
Contact column created by formula keeps reverting to text
Hi Smartsheet Community. I'm hoping that this is a setting or something simple I'm missing. I have an employee list of 1500+ employees that is being auto-updated by our IT team once a week. Currently the weekly info dump puts in the Name and Email address (along with a lot of other information that is useful, but notโฆ
-
Help pulling contact list to a different page INDEX/MATCH/VLOOKUP
I am having difficulty pulling a contact list into a page. My page is set up of INDEX/MATCH Formulas that bring over various pieces of information based on the unique identifier. When I write the Index Match Formula for a contact list I get unparsable/incorrect argument.
-
ISBLANK Question
I need a qualifier to ignore blank cells in this formula: =IF(AND([Due Date]@row < TODAY(), NOT(Status@row = "Complete")), 1, 0) Right now this is counting blank date fields as "1". I see the ISBLANK modifier but is there a NOTBLANK argument in SS?
-
I need help discovering a sum formula for a specific criteria in a column
I am trying to figure out a formula where I can find the sum (total cost) of specific criteria in a column. To further explain the breakdown of what I need: I have a "Total Spend" column and a "Sales Region" column. The Sales Region column includes WC1, WC2, WC3, WC4, GP1, GP2, GP3, GP4, NE1, NE2, NE3, NE4, etc. I amโฆ
-
Vlookup referencing formula field
I have a text/number field which is populating by using the =Left formula. I then want to reference this field using a vlookup to another sheet and pull in the corresponding information. I keep getting the #UNPARSEABLE error, and I've determined it's due to formatting, but not sure how to fix. As an example, I have aโฆ
-
RYG in Formula Gives Text as Answer
Hello Gurus! I have the following formula that seems to be working well, except it is displaying the answer as text instead of the RYG ball: My column type is set to symbols (specifically the RYG balls). Any ideas?
-
Update Formula to Check for Blank Value and Use Static Value in its Place
I have a sheet that my company uses to track when a resident is being moved from their apartment into a temporary apartment and a permanent apartment while we renovate our apartment buildings. Each resident has one row, with columns to track their original unit, original unit move out date, temp unit, temp unit move in andโฆ
-
If formula help needed please
Good afternoon, I'm hoping someone can help me trouble shoot my "IF" formula please: =IF([Wks since Request]@row = 0, "Emptey", IF([Wks since Request]@row = 1, "1 Week", IF([Wks since Request] = 2, "2 Weeks", IF([Wks since Request]@row = 3, "3 Weeks", IF([Wks since Request]@row >=4, "4+ Weeks" Thanks for your help!