-
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…
-
Contacts not Showing up in alert someone automation
I am trying to set up an automation within one of my work books. But when i go into automation and set up to alert someone. The contact is not showing as an option to send the alert too. Their names/emails are set up correctly in my Smartsheet contacts and within the Contact list i created within the workbook Thanks!
-
Auto-Create Child Rows WITHOUT Bridge or API
This initial solution is based on form submissions being made and each form submission triggering the creation of a set of "template" child rows per submission WITHOUT the need for a 3rd party app, the premium add-on Bridge, or the API. So if your form submissions look like this: Your working sheet could look like this:…
-
Icons Links in Dashboard
Hello All, Please tell me how to add pdf, excel and word icons with the in the dashboard.
-
Calendar App on Dashboard - First rows not showing in display (not a filter issue)
Hi All, I've added a Calendar to a dashboard, and the first 1 or 2 rows on calendar are not displaying. I know the content on calendar is correct (confirmed when viewed outside of dashboard). There are no options or ability to scroll up to see the top content, nor does resizing the widget correct this. First image is of…
-
How can I add Sprint Planning to PMO enviroment?
Does anyone have ideas on how to utilize the PMO template and add Sprint Planning to it? All my tickets and project tracking happens within the PMO folder. I would love to use all this information to plan my sprints. Anyone doing this already that can give me some guidance?
-
Dashboard Metric Widget Not Updating with Current Backend Sheet Value
Hi all, This is from a sheet that uses a formula to count down / display the number of days til end of Quarter. What is happening: Displays 37 when the backend sheet actually says 34. The dashboard does not update until I click to open the backend sheet then the connection seems to go through to update the…
-
Icons
Am I crazy or are there new icons for sheets, reports and dashboards in the solution panel? Same in the Browse but new elsewhere?
-
Smartsheet + OneNote
To avoid duplication of entry for those who prefer MS products more integration/automation between MS products like OneNote are necessary, especially for large teams or cross functional projects. Many teams use different tools to track notes and progress, this is becoming critical to our ability to continue to be able to…
