-
Organizing/Sorting Workspaces
Hello Fellow Smartsheet Community Members, I am wondering if anyone knows if it possible to sort items in a workspace by the item type. I have a workspace that has a mixture of sheets and reports. Ideally, I would like a way to group all the reports together and all of the sheets together. An anaology is clicking the…
-
Creating Different Update Request Formats
I send update requests every day. However, when I send them, I have to keep removing some of the columns as those that I remove are not necessary for the person to see. Is there a way that I can save an update request format with those columns removed so I can quickly choose the right formats for the specific person I am…
-
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…
-
Screen Capture of Sight
Hi, As it is not possible to control the printing of a sight (it only prints within one page, which is not usefull for larger sight), does anybody know a screen capture tool that would scroll throught the sight and grab all the data? I have tried several (on Mac) but not seems to be able to scroll automatically and grab a…
-
Email Notification View
We use Smartsheet notifications and receive emails frequently letting us know that a task was completed, and it is now our turn to work on a task. We use MS Outlook as our email client, and within here I like to use the preview pane. When I receive the Smartsheet notification, I cannot see the task that is ready for me to…
-
Formulas with Conditions
Hello, My goal is to have a formula populate the dues dates with one condition. Currently Drawing Due Date is populated 2 weeks from Order Date If the "Type" Column is "Q" then I need the Drawing Due Date to be 1 week from Order Date. Current Formula: =$[Order Date]289 + 14 Thank you for helping me with this in advance.
-
Formulas
I want to create a formula in a cell that subtracts a certain number of days from another cell that is linked to another persons Smartsheet. How would I do that? My efforts have failed.
-
Gantt Report for Several Sheets - Can I drag & drop dates in the report?
I would like to be able to drag & drop Gantt dates in my report as we have several projects going concurrently, and the report is great for big picture. How do I do that? Also, how do I reflect a pause in a project, as in we're waiting for info from a client but are working on other jobs in the mean while? I would like it…
-
Links with Logic
I have two sheets that I want to share information across. Sheet1 contains hundreds of part number records and standard data fields required for each part number. Sheet2 contains essentially a task list of needs to be addressed each of the part numbers on Sheet1. The amount of tasks per part number is highly variable and…
-
Client list in card view
Hi guys, we've been using smartsheet for about a month now. We have our client list set up in card view which is taken from my smartsheet contacts. If you hover the mouse over the contact it only shows their name and email address. Is there anyway this can come up with their phone number too? We have phone numbers set up…