-
Is there a way of conditional formatting cells with dates with a hyperlink attached.
I have conditional formatted all cells to fill green when the date is in the past 730 days (2 years), and to fill red when the date is before 2 years ago. Those are the only two formats I have for every cell. Now I want to add a hyperlink to each cell. I use the CTRL+K function, type the URL and display the same text as…
-
Pull Report from a Control Center Project that includes the row on the Intake Sheet
Hi there community, I'm hoping there's a guru out there who can help me! I'm trying to create a report that includes different sheets from a project that was provisioned with control center. HOWEVER, I want it to include the row from my intake sheet that the project was provisioned from. The report that I'm trying to…
-
Syncing task to Outlook Calendar
Hi, when I sync my task list with Outlook Calendar, it shows in Outlook as a 'tentative' event that needs to be 'accepted' or 'declined'. I am wondering if there's a setting to change it, so it will add it directly to the calendar rather than showing it as a tentative entry. I looked in settings but couldn't find that…
-
Bridge - Filter an Array Object by a Particular Field
I have an array of objects that I need to filter and find a particular field in Bridge. ex. [{name: 1, id: 123}, {name: 2, id: 321}] In this case, how would I select the id for the "name" key/field whose value is "1"?
-
Can I link a Smartsheet dashboard to a sharepoint page? Please read the task below:
I am trying to link a Smartsheet dashboard to a Sharepoint page but this Smartsheet is edited twice a year and specific people need access to modify and then the rest of the business needs access to just view. How do I do this?
-
Data Shuttle 'contains' filter does not return any results
I am trying to filter a column that has a list of document names. Some of the documents are 'plans' Example: Onsite First Installation Plan - v08 I want the filter to only return rows where the document name in the row has the word 'plan' in it. When I try the contains filter, Data Shuttle filters out all the rows and…
-
Failed to Load Request error when adding Shortcut from DropBox to Dashboard
When trying to add a shortcut on a SmartSheet Dashboard to a PDF in DropBox, we are getting the error "Failed to load request." We do this all frequently. There are a few files we added last week that are still available and we can reattach. However, any other files are not attaching. Is there a SmartSheet or Drop Box…
-
Why is my Document Builder not working?
I am attempting to generate a document from one of my sheets but the document builder is not allowing me to create a document. It is working in another sheet but not in my current worksheet. I was able to create a new document mapping in a different worksheet so I am confused why my currently worksheet is not allowing me…
-
Data Shuttle support
Hello I currently have one main sheet used as a central repository. I have another sheet in which I have manually populated data from the main sheet. I would like to use Data Shuttle to automatically populate that data every week. Thanks
-
Workflow Form Automation
Hello, I'm trying to expand a current workflow to allow multiple users to fill out the same form . I haven't figured out if it's possible yet for a second or third person to work off the same form so all of the information can be captured into one line item in the sheet. After the form is submitted the automation is set up…
