-
automation to update a date field to new value
Hi, I am trying to set up an automation where it detects when a date found in column DATE is passed and then would automatically update it based on the value found in the column frequency for example : if the DATE = 01/07/2021 and the frequency = Weekly then when we pass the date 01/07/2021 it should automatically change…
-
Logic Project Plan
Hi , Need a help on the project plan logic related to Sch Health. The logic i am using on the schedule Health is not showing me the correct result. As you can see Start date is 06/01 and End Date is 06/30 the % Complete is 50% ideally it should be green because it just a week and the % complete is 50% Can any one help on…
-
Data Shuttle / Only works once with manual trigger
New Data Shuttle user here... Background: Pulling from an Excel file stored in my OneDrive. No automation at this time, triggering the upload manually as I test the approach. Issue: I can get the initial data pull to work just file. When I update the source data and manually trigger a second time I get a successful run…
-
Weird outcome with Large function
I am experiencing a weird scenario while trying to use the Large function. What I want to do is to get the two most recent dates from a column with numerous dates. Please check the sample datasheet: The Dates column contains the dates and I am showing the two most recent dates in the column Recent Dates. I am using the…
-
Attaching files best practice
Hi We are rolling out Smartsheet and we are a MS shop which means we use Teams, OneDrive and SharePoint. I understand that if files are attached from OneDrive, it is a link to the file and will always point to the latest version of the file. This is not the case for SharePoint. We are considering to only "allow" a URL to…
-
Filter reports - How to
I'm building a late task report across multiple workspaces/plans. The filter option is not available when viewing report results. Looking to be able to filter by "Status", "Owner", etc.
-
Merging A list to show unique value/identifier
Hi Smarties, I am wondering if anyone could share some ideas on this. I have a list of available products. Some of these products are repetitive in the list. For example I would like to show a list of AVAILABLE products in the dashboard, but without the duplicated products. So ideally, it should be showing in the dashboard…
-
Conditional Logic - Setting a Value
Hi - I know a few months back Conditional Logic was added to the Forms which is awesome. I was wondering if there's anyway (that I'm not seeing) where I can use a Dropdown, Radio Button, etc. - to set the value of a Status field. In other words, If Someone Selects Option A from the drop-down, then Status 1 is set, Else,…
-
How to have a date dynamically changed based on a value in another column?
I'd like to be able to have the dates in a column update based on the Sprint number. So, I've created a new sheet with one column with the Sprint # and a column for the associated dates. I have a column in my main project spreadsheet titled Sprint #. I'm having trouble figuring out how to tie it all together. I've been…
-
Filter for Current User with multiple contact column
I have created a sheet filter "my todo´s" for the current user. This works if only one contact is entered in the filtered column. But we have enable multiple contacts for that colum. Is there a possibility to build a filter "contains the current user"?
