-
If cells in formula are blank, then leave the formula cell blank
I have three main columns: Planned Start Date, Planned End Date, and Date Completed I am utilizing the formula below to determine which tasks are done and late in the status column. I would also like the status cell to be empty if the date completed cell is empty. How can I do that? For some reason ISBLANK isn't working…
-
Time Formula - Drop Down Selection
Hello, I've searched and it appears the time formula is an ongoing battle for enhancement requests. Looking for some help, I have two columns; 'Start Time:' and 'End Time'. There is a drop-down box on the web form and sheet that starts at 12:00 AM and ends at 11:55 PM, all increments of 5 minutes. For example, 12:00 AM,…
-
Multiple vendors and corresponding part numbers
We are using Smartsheet to manage inventory. We purchase the same materials from multiple vendors, depending on pricing and availability. Is there a way to list the multiple vendors with their corresponding part numbers without indenting lines for each vendor below each and every item? The time required for that solution…
-
Share into a Workspace
Hello, I have been looking for the solution to share into a Workspace. I see the Workspace and I have Editor access. I do not see the options on the sharing sheet checkbox or under Home from the screenshot. Please advise if I am missing some settings. Thank you! Tom
-
How do you pull form data in sights directly from a sheet?
I am trying automate pulling data entered in the form, that pulls into the sheet to then pull into a sight without using a report as the formatting is not very good, can anyone help?] I have attached a screen shot to support above. Thanks
-
Page break / separation between years / header
We have a pipeline report pulling data from a primary sheet that we need to separate out by year. Is there a way to add a row or page break to distinguish and separate the two years? Also, In regards to header row at top of reports is there a way to make the font larger and the width of the column itself larger in just the…
-
Type selected - allows certain columns to be updated
The checklist type smart sheet will be setup with columns called Vendor, Type, Doc 1, Doc 2, Doc3. What I want to do, is depending on the type selected for a particular vendor, the doc columns will grey out for those doc types needed for that specific doc type. For Example: Vendor 1 Type Critical All doc type columns would…
-
Populating a sheet from a Webform
Is there any capabilities regarding populating multiple lines of a sheet from a web form? My company uses Smartsheet as an AP tool where vendors submit there invoices through the web form I created. My company has over 150 sites nationwide and over 300 globally, so some vendors we have are global as well and invoice 50-100…
-
Independent work days for tasks or resources?
I have holidays blocked out in my calendar, however there are certain tasks/resources where the holidays don't apply. For instance, China is closed for all of February for Chinese New Year and I have those dates blacked out, but I don't want them to apply for folks in USA who will still be working. Is there a way to either…
-
Importing auto numbered columns
I want to be able to import an excel file that will create auto numbered columns (date created and auto-numbered). Is this possible? What I am trying to do is as follows: I have created a template to make training quizzes for different departments. I want to make an outline in excel where employees can type in a list of…
