Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
I've read all of the other posts about this formula, including the Blog, but i can't seem to get this formula right. Here's what I'm trying to do: Due Date TODAY(-5) = Green Due Date TODAY <4>0 = Yellow Due Date TODAY+1 = Red Date Completed = Blue I can get the RYG balls but I can't figure out how to ADD the criteria for…
Outlook and Office 365 Integration
I cannot seem to set up outlook and smartsheet together as i have a subscription and cannot make the integration work. Previously at another work place, i was able to download the add-in on outlook directly and everything worked excellent. Can anyone offer advice?
Jira Connector End Date one way???
I have set up our jira connector to send an end date over to smartsheet. however, if I enable dependencies, the connector changes this to a single direction from smartsheet to Jira. This has changed a load of dates in jira that i didn't want it too! Why does it do this? and does anyone have a handkerchief i can cry into?
I have a SmartSheet that I would like to share with multiple Vendors. However in the documents are some sensitive data that these vendors should not see. How can I share without having to create a separate documents.
API - Bulk Operations Documentation
Does anyone have or know where I can get some information or an example on the Bulk Operations for the API? I am writing an app that outputs data to SmartSheet, however it seems to be a bit quick for SS as it throws errors saying it's already being updated by another process. It only succeeds if I put in a 300 ms delay. So…
Not sure why I'm getting Invalid Data Type
Hello! I'm trying to check a box to send an notification to our PM if: 1. column A [Best Day and Time for Service] is less than or equal to 7 days away 2. Column B [1st Visit: Date] is blank AND...if column A is blank, to leave the box unchecked. When I put a date in Column A, it returns "invalid data type" in my column…
Identify all cells that contain a formula?
I'm trying to look at all my formulas and am wondering if anyone knows of a way to (temporarily) highlight or identify every cell in a sheet that has any kind of formula in it.
Smart Sheet Freelancer Required
Seeking an independent Smart Sheet Consultant to begin work no later that the 31st October 2017 6:00 PM GMT You should be able to screen share and use our already uploaded excel spread sheets to create reports.and sights. You should be able to use the advanced functions of cell linking and formula to create forecasts.…
Enhancement Request: Allow Row Number retrievable from formula
I thought I had written an enhancement request for this before, but I have no record of it. I'd like to be able to retrieve the row number (not the ID, the number) using a formula. Some use cases: In this thread (https://community.smartsheet.com/discussion/finding-duplicates) Joel talks about having to sort prior to…
Outlook Integration - Contact List not pulling through
Hi, when using the Smartsheet Outlook add-in, one of the entries is a contact list selection, whoever no contacts that I saved in the original sheet are pulling through in Outllook. Any idea why? Thanks, OJ