-
Converting a date/time text format to a simple date format
Hey everyone - I am trying to convert a text field that reads 2024-09-25 15:35:27 to a simple date format, either 2024-09-25 or 9/25/24. I've tried using a helper column to just pull out the text date string - =LEFT([Registration date]@row, FIND(" ", [Registration date]@row) - 1) in the hopes that would be convertible to a…
-
Counting with Multiple Values per Cell
Hello! I'm trying to count the number of times a word is used in a column. The column allows for multiple values per cell, but my formulas only count one of the words in the cell and not both of them. For example, the values in the column are Yellow, Green, Blue, Red. There are times when Yellow and Blue need to be…
-
can i change a cell after a created date is past a certain amount of days?
I have a sheet for purchasing requests. Often time, after a purchase is received, the purchaser will forget to change the status dropdown from ordered to received. Is there a way to use automation to change status from ordered to received when 90 days have passed from the created date?
-
Is there a way to make reports on a dashboard interactive?
I would love to be able to check off items in a report directly in my dashboards, without being redirected to the source report or sheet. I cannot see how to do this - is it possible? Thanks Hannah
-
Formula or Automation Help
Im looking for the best way to set up this formula/automation (whichever is best): I have multiple columns collecting different contact names by title from a form: I need a formula or automation, that when "Admin Reviewer" = yes, then it takes the contact in "Project Admin" and adds it to another column titled "PT Proof…
-
COUNTIFS for Previous Month Data
I am trying to create a metric for a Dashboard and need a count of items that were submitted the month before current. I am using as reference "{HDP Late Add Request Request Date}" column. I am currently counting the metrics for the current month and the formula is working. I am not sure where to add the criteria to the…
-
Need formula that will look up a cell in another column, if true return "Complete", if not "Waiting"
This is the formula that works in excel - I cannot replicate in Smartsheet Essential what I need is If the item in column A is in Column B return "Complete" if not return "Waiting" '=IF(IFNA((VLOOKUP(A2,'[Win 11 Upgraded Assets.xlsx]CDN All Windows 11 23H2 Workst'!A$1:A$3700,1,FALSE))," ")=" ","Waiting","Complete")
-
How can I display data horizontally from data in a row format
I have metric data on a project that I am capturing weekly that I would like to view horizontally week over week for the current month. I'd like to do this dynamically so I can pull the data into a dashboard. This is what I have in my metrics sheet: This is how I would like the data displayed: Any advice you can provide to…
-
Sorting Queried Data in Descending Order
Hi Everyone, I was wondering if there is a way to sort queried data in descending order. I'm aware there is no explicit SORT function and the way I set up my data sheet, I am unable to sort the rows/columns that way. The formula I am using is as follows: =JOIN(COLLECT({Domain}, {Status}, "DONE"), CHAR(10)) This is…
-
Smartsheet Report
Hello, I am building a row report and I am running into some roadblocks. I am trying to show the number of client requests we received in the last seven days, how many we resolved in the last seven days, how many cases we still have open, how many have been still open (pending) in 15 days or more, and how many are pending…
