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.
Discussion List
Sharing Smartsheet
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
Form Reminder
Is there a way to set up a daily reminder via a web form without having to share a sheet with the individuals who will be completing the web form? Scenario: I have a report that needs to be ran daily by a dept. outside of my office. The report should be ran each morning for the data from the day prior. I created a web form…
Using smartsheet to survey clients (net promoter score)
i'm looking at whether to use survey monkey or smartsheet for a client survey. I'd like to be doing regular surveys so am thinking smartsheet. Has anyone used it for this purpose? What should I know before I start? Is it better than survey monkey? Thanks
Status RYGG Automated Formula
Hello, I am trying to create a status column which updates automatically based on the following criteria: * Green (Task is Complete): “% Complete” column = 100% * Yellow (Task is In Progress): Today’s Date is less than “Planned End Date”, and “% Complete” is less than 100% * Red (Task has not Started on Schedule): Today’s…
