Does anyone know if there is a way to get a Date to generate when a project is set to approved? I want to be able to set a target date using the time stamp from when a concept drawing is approved to when we will need to ship samples.
Smartsheet does not currently have a timestamp feature. Many of us have begged for something like this, but alas, there is nothing to this date. Please submit a product enhancement request to add your vote for this feature.
I have a contact sheet and a main sheet. There are instances when I have 2-3 individuals that need to be notified based on the information on the main sheet. I created this formula to pull multiple emails from the contact list: =JOIN(COLLECT({Department Chairs}, {CourseName}, CONTAINS([APA Courses]@row , @cell )),…
I have created a SmartSheet Travel and Resource calendar where my organization logs in their travel dates, to which operational sites we visit, etc. Each team in the organization has its own sheet, but a dashboard consolidates the information. How can I build a table in the dashboard, that dynamically updates, to show who…
I am designing a budget sheet and want to Sum a series of cells if they meet 2 conditions. 1st I want it to check an expense category, ie. groceries. I then want it to check that it falls within a specific date range. Below is an example of the formula i have built and it works: =SUMIFS({Expense Collector Range 4},…