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
Best way to load a file in sights that can be updated
I want to have pdf files on my site and an easy way to update them. I tried loading them in google drive but when I update the file in drive the link on my sight is still the original pdf. sometimes we update a pdf several times a day, what is the best way to do this?
Conditional Formatting - Target Dates vs Actual Dates
Hey guys & gals Basically I'm trying to get my actual task finish date to highlight green or red if it hits or doesn't hit the target date. I know I need a checkbox column to do this. I've added one with the following formula =IF(Finish2 > Baseline2, 1, 1) Finish2 = the first cell with the actual finish date Baseline2 =…
Hospitality Industry (Restaurants)
Is anyone using Smartsheet for their restaurant clients? My thought is to setup a wordspace run everything from new employee forms to inventory counts.
Excel sync
Hi there, does anyone know if it is possible to synchronize excel data with smartsheet. My problem: our erp system can export lot's of project data to excel. So it would be nice to sync a main smartsheet with the erp data and have nice things like sights and more ... thks Peter
Pre existing excel spreadsheet into smartsheet
Hello I have 2 existing excel spreadsheets that I want to put into smartsheet approach, so everyone can add/wotk on it as needed. What is the best way to do this? Thank you! :)
Calendar for Media Planning
We are looking for a calendar solution to keep track for our advertising placements. We place about 100 ads per month, in multiple publications and multiple sizes. We would like to be able to see the calendar as a list by publication, publish date, deadline and as a standard calendar view. I checked out the templates but…
Smart sheet Connection string for ODBC connection.
Hi, Am Using the Smart sheet connector to connect smart sheet using qlikview. Qn: Smart sheet ODBC connection string with API to place in qlikview script for automated connection
Enhancement request
Would like to be able to select more than one fields data to show with the gantt line and on the calendar. This would solve a huge problem we are having right now with being able to see who is working on what. The shop guys only see the calendar view to tell them what jobs are scheduled and on what piece of equipment. With…
Are there limitations on CheckBox columns?
I imported an XLS file that has 4 columns that I want to convert to checkboxs. When I change the properites on all 4 columns to checkbox, the columns act as if they are text. If I change any of the 4 columns to text, the other 3 will show a checkbox in them. Is there some kind of limitation on the number of checkbox…
Help with formula to count BLANKS in Assignee field across multiple children rows
Hi all, I'd like to count only the rows below where the Assignee field is BLANK. The problem is my formula is counting the parent rows (ECS Inbound, ECS Outbound, Flat File Inbound). I know that =COUNTIF(Assignee28:Assignee60, "") will count blanks but how do I get the formula to only count the rows in that range if they…
