-
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…
-
Please help with the following formula to return '% Completion planned' with conditions:
I have the following columns for tasks: Planned start date Due date Planned duration; calculated as =1 + ([Due date]@row - [Planned start date]@row) Days remaining or overdue; calculated as =[Due date]@row - TODAY() % Completion planned; calculated as = 1 - ([Days remaining or overdue]@row / [Planned duration]@row) I am…
-
Index Collect Permissions
Hi all, I have a Smartsheet which looks up values from another sheet using Index Collect, which is working well. However other users with Smartsheet license and with a free license will be loading the sheet who don't have access to the source data sheet. I don't plan in opening the this (the destination sheet) hoping that…