-
Convert text to date
Hi I have a column containing text, which contains a date in MM/DD/YY format, followed by a longer string of text. For example, one of the cells contains "07/26/22-G" I want to populate another column, with column type = date, with the date, so that I can order by date. I tried this using this formula =MID([Test1]@row, 1,…
-
Populate the Day of the week using a calendar date
Is there a magic formula I can use to populate the day of the week (Mon, Tue, Wed, Etc...) given the calendar date in another field? Ex: Calendar Date Day of Week 08/18/2021 Wed 08/19/2021 Thu Thanks!
-
formula to return what day of the week a date is?
in Excel this would be the formula =CHOOSE(WEEKDAY(A1),"Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat") Does not work in SS?
-
Summary Formula
I'm trying to get a formula set up in the sheet summary to get rows added within the last 90 days, and then a vlookup to get a cell value. I've tried numerous formulas but they're all coming up with an error =IF(TODAY() - Created:Created <= 90, VLOOKUP("Reviewer", [Peer / Reviewer Rating]:Trust, 10, false),) any ideas…
-
Help Summarizing Two Columns
Hi there, I'm currently trying to summarize two columns and keep receiving the #UNPARSEABLE error. Essentially, I have one column that lists the month, and another that lists one of our sites. I would like to summarize how many rows there would be for Site1 in January, for example. January + Venue1 = Value I am completely…
-
February 29th Automations?
Hi all, This may be a silly question, but if I have set up automations on my sheets to be performed on the last day of the month for February to re-occur every year and it was set up on the 29th February, will I have any issues for the following years? Basically asking does Smartsheet recognize leap years? Thanks!
-
Calculating 2 criteria from one column up to a specific date, also including a check box reference
I'm trying to calculate data from a status column that has drop down options of 'in progress' and 'not started' and see how many from those 2 criteria return an end date up to the end of June 2024 (working days will be 28 June). Also ensuring that a check box for if it's being reported is checked. I'm using a sheet…
-
Index Match is not returning newer rows from parent sheet
My index match on a sheet has some rows missing that are on the source sheet. When I check the Index Match formula, all is well (and is working for all of the other rows). I checked and it is converted to column formula. When I go to the source sheet, the row that is missing in my new sheet is formatted just like all of…
-
Counting individuals supported by specific customer removing repeats
Hi, I am trying to sum the number of individuals that are supported by a customer. There are several opportunities that support a single customer and within these opportunities the same individuals may be supporting the customer. How do I calculate the unique number of individuals who support a single customer. The…
-
Is there a way to create an automation to change a cell to a formula?
I'm trying to copy data from column to another, but only if certain conditions are met (i.e. if a separate column is checked or has a specific drop-down selection). I tried creating an automation with conditions that writes a formula to copy the cell into the column I want, but it adds a ' to the beginning of each function…