-
Column with Remaining Days
Can a column be added that can display the remaining days of a task ? and How can be this done. Thanks
-
Freezing Columns Creates Two Scrolling Panes
Being used to Excel and setting up Panes for large sheets, we were delighted to find that if a column is frozen well to the right in a sheet, the "freeze" line can be drug to the left to make both sides scroll horizontally. Hope this is a helpful hint for someone searching for Panes.
-
Can I use Find in a count formula?
I have a spreadsheet that is a calendar for consultants. I have the primary column using the consultants name as the Grandparent, the Month as the Parent and the weeks of the month as the children. * Consultant * Month * Week * I have another column that shows availability using RYGG for different status'. * What I want to…
-
Super cool! Box integration and email upload
We use Box.com to store and collaborate on files with both internal and external colleagues. If you do too, here are two cool features you may not know about. 1) You can "attach" files stored on Box to your SmartSheet row. When a user clicks on the link to open the file, a new browser window opens inside of which Box opens…
-
Notification Sent to Assigned Contact 4 Weeks Out...
Hi there, We run about 200 events per year and need to inform our trainers that they're assigned 4 weeks before the event start date. I know I can use the Reminder feature to send a reminder up to 2 weeks out, but that's not enough lead time. The master sheet we use is initially populated as an "Event Request" using a…
-
Gantt Chart + Start/Finish Columns
I have a need to combine the detail of the start/finish date from the grid view with the visualization of the Gantt chart view. Is this possible?
-
Conditional Format by cell unique based on row or column
We are undertaking major project across teams and areas and looking for a way to create a dashboard type display with ability to add spcific details. Basic requirements include. 1. We have 16 different workstreams grouped by column (overall status, staffing, planning, security, rerporting etc.). There are about 30 modules…
-
web form for order form
I'm new to Smartsheet. Have created a sheet with a web form to be an order form for our customers. In part of the form I'm wanting to provide our customers with the functionality of entering quantities for our various products, how do I do that? Thanks :)
-
Report missing row after additional row added in smartsheet
I have a smartsheet set up with all transactional sales for each region (including status, probability etc...) I also have a report written looking specifically at just one region. However, when a new line/row was inserted in the smartsheet the detail (new line) has not fed through to the report. The totals are correct…
-
Remove boldening on the 2nd item in Gantt chart
I apologise if this is a simple question; I am new to using smartsheet. For the Gantt chart attached, I notice that the 2nd row on the Gantt chart has bold text; how do I go about removing this? For context, the Gantt chart refers to a project that consists of 3 mini projects within it (in grey). And the constituents of…
