-
Formula Expert Help Needed (Number of days for Oldest Ticket, Count all except blank & Closed status
Hi Smartsheet Formula experts! I spend a lot of time scrubbing the community board for formula help and thankfully I usually find my solution. (Thank you all!) However, I'm trying to build this sheet summary out and after about 2 + hours, I'm reaching out to the experts in the community. Screen shot of the metrics I am…
-
Current week & previous week
I have a sheet with start date and finish date columns and a column to insert current/previous or blank (if the dates are neither current or previous weeks), so was thinking the formula would be something like if today's date is greater than or equal to the start date or less than or equal to the finish date insert…
-
Translate excel formula into Smartsheet
How can I translate this formula to Smartsheet? =IF(ISNUMBER(SEARCH("vPGW",A1)),"vPGW", IF(ISNUMBER(SEARCH("smf",A1)),"SMF", "")) Thanks
-
Creating an IF formula based off two columns where it can group the data by a timeline logic
Trying to find a way to automate our sheet by using the IF formula to pull data from two columns [status (i.e Sent, Scheduled) and date column] to build a logic to pull a timeline (i.e today, tomorrow, next week, 2 weeks, done, TBD.) into a new column. This is the formula I've built but isn't working, where did I go wrong?…
-
Getting a NO MATCH when using Index/Match in a formula
This has been working very well on previous sheets. This is a Titration Log and it varies per plant and therefore very tailored to their line and parameters. In the steel business - so you'll see substrate as to what I am matching. I have a column that does the look up and returns "red" if out of spec. The ALUM formula is…
-
Countif requirements are different from cell to cell?
I'm calculating a count per month. The September field calculates correctly using an equal sign and the month to count. However, October requires me to remove the equal sign to calculate the count. The referenced column is the same in both months. Why is this happening and how is it corrected? See below pics:
-
Extract Email Address Only from Contact List Column Upon Export into a Spread Sheet
Hi, In reference, to the above subject, I would need an help to view or extract only Email address from the Contact List column when I export the Smartsheet sheet to Excel spreadsheet. Thanks! Khushboo
-
How to sum across multiple columns
Hello, I'm looking to calculate across multiple columns and have the formula total it in the end column but I can't figure out the formula to do it, I keep coming up with #UNPARSABLE. I've attached a snapshot of the sheet
-
% Complete Formula based on Start/Finish Dates
Hello! I am in need of help writing a formula to auto-calculate the "% Complete" column based on the "Start" column date and "Finish" column date. Additionally, I also have an auto column for "Duration". The goal is to have the % Complete auto calculate based on the today's date in relation to the start and finish date…
-
Help With SUMIFS Formula
Hello, I'm trying to retrieve SHIPPING COST for the current month of DATE REQUESTED for all repairs under ACTION TAKEN for the WARRANTY ACCOUNT “41130”. There are 4 different columns I’m trying to draw data from and I’m not too sure how to sequence the formula. All caps words are the columns I’m trying to include in the…
