-
Displaying who the current user is on a dashboard.
I have some dashboards set up sharing reports set up for current user. I'd like to include a who the current user is at the top of the dashboard. Thinking there is a way to use a metric sheet.... Would appreciate any thoughts on how to do this. Thanks, Sara
-
what is wrong with my formula join collect?
=JOIN(COLLECT({Rollup Tracking: Preceptor Activity Month}, {Rollup Tracking: Preceptor Activity Preceptor Name}, [Preceptor Name]@row, {Rollup Tracking: Preceptor Activity QTR}, Qtr@row, {Rollup Tracking: Preceptor Activity Year}, Year@row), CHAR(10)) I cannot see why this doesn't work…i have similar formulas on other…
-
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…
