-
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"?
-
Can a dashboard be exported to a Google slide deck?
I would like to take parts of a dashboard and roll the data into a preestablish Slide deck
-
Document Generator from multiple rows into one Document
Can I select multiple rows to a single document to "Mary": Name item Qty Price Mary 1234 01 $10.00 Mary 2345 02 $35.00 Mary 3456 01 $90.00 Mary 4567 10 $ 5.00 Also, will the document generator create multiple pages based on text wrapping? Thank you,
-
Forms Workaround: Submit button opens new form to allow sub-info - How do I stop when user is done?
Please help! I'm stuck. Goal: Create a form customers can use to report a problem with an order. The order may have more than one line item (i.e. Customer ordered 5 received 3 of product #1-ABC and ordered 3 and received 5 of product #1-ABE, both on same order) I want the customer to be able to provide their contact…