-
create a filter/checkbox to identify rows created after 12:00Pm
I would like to create a filter/checkbox to get the rows created after 12:00PM to 5:00 PM same day. Is there a way we can do this?
-
Average calculation from overall ratings
Hi All, I'm trying to calculate average of these rating in Average column excluding "NA", for example if "NA" is applied in any column the formula should exclude that column and calculate for the remaining columns. Please help me with the formula.
-
IF / AND formula help
Hello, I would like to add a condition to an IF formula that changes the health colour only when the Due date is not blank. Please can you assist? At the moment the formula looks like this which works fine for tracking due dates: =IF(Status@row = "Complete", "Green", IF([Due Date]@row = TODAY(), "Blue", IF([Due Date]@row <…
-
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
