-
create form from text file or spreadsheet
Full disclosure, I just initiated a trial of Smartsheets and haven't yet taken the time to learn its features; this might be as easy as copy paste. Is there a way to create a form from a text file or spreadsheet list? I have a long list of items I want to track during user tests, and thought a form might be a good way to…
-
"Pretty" PDF export -- Google merge, something else?
Hi all, We’re hoping to be able to export a fairly complicated styled PDF from Smartsheets. Imagine a sheet of movie reviews, where Column A is movie title, B is review, C is reviewer and D is date. Each movie can have multiple rows depending on how many reviews it’s received. We’d like to get a PDF that would look a…
-
Duration Column Doesn't SUM up Correctly
Hello, I am using smartsheet for my master project plan and I repeatedly run into one issue, my project Duration count roll up is inaccurate. I have attached a screenshot to provide a better understanding of the issue.
-
View today, including one day and multi-day items on sheet
We track all our promos on one sheet. Some of them run one day, some of them run for several days, some of them run more or less permanently. I need a view of everything running on a given day. The filters do not appear to permit this. Any ideas? Ideally, would like this to run in calendar and gantt views. Alternately, is…
-
Grid
Good afternoon , I would like to take off from the first few lines from my sheet the grid not from the total sheet only from the top is their to do that . if so i can make my sheets into a nice looking invoice now i download it into excel and do it from there any ideas ?
-
Resource Management across two companies
We have a parent company that shares a sheet with one of the departments within our business. We have a staff holiday planner to provide ourselves with resource management. Is their a way that this can be fed back to our parent company? Many thanks
-
Order of columns to select when sending email
When I want to email someone, I don't want all the columns sent in the email. I click on the edit columns to select what I want to send. Many times it's just one or two columns that I want to send. However, it is very difficult sometimes because we have a sheet that contains many columns. The order of the columns seems…
-
Alerts for Blank Fields
I want to create an alert or reminder when a field on a certain row is blank. It can't be a required field because the data is entered after the row is created. Does Smartsheet have this functionality? I don't see these options available today but thought I would ask if others have attempted this. I am currently exporting…
-
Delete all rows in Smartsheet using API call
Hey, I have a fairly large Smartsheet of about 500 rows which I am accessing through an API call. Is there a way to delete all rows in the sheet using DELETE API request without mentioning all the row ids separately?
-
Sheet limit within Smartsheet
Hi everyone, I'm about to embark on a large scale server back up and am hoping to keep all of my data logs on Smartsheet for safety. There will obviously be a massive amount of sheets to hold and I was just wondering if anyone knew the limit on how many sheets you can host? I'm a licensed user and am part of a team…