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. Archived 2017 Posts
Archives for January 2017
Discussion List
BUG: Update Request tab shows incorrect value
I created a single Update Request to three different users. One of the users updated the UR. When I went into the sheet, the tab still showed Update Requests (3) until I opened the dialog at which time, the number changed correctly to (2) I think this is reproducible. Any one else seeing this? Craig
Cell linking with conditions, possible?
I am trying to create conditional cell linking across multiple sheets that all tie together. i.e. If this cell=A then make the Harvey ball blue across all sheets, if this cell=B then make the Harvey ball green across all sheets, etc. Is that possible?
Smart Sheets Merge with Google Docs
HI I started to use the merge Feature to get my sheets into a Proper form so i can send it as an invoice to my customer (as Per link Below ) https://www.smartsheet.com/videos/work-smart-webinar-merge-data-from-smartsheet-into-google-docs but my issue is that when im trying to send it in 1 pdf / 1 form for Mutiplel Row…
Combining calendars with work plans
Hello, My organization has the team plan (not Business). Is it possible to create a graphical calendar view that reports/displays results with a traditional project/work plan by department or function with tasks/activities? If so, can you only create this on the same page within Smartsheets using Sights? I suppose it would…
CAB Change Advisory Board
Anyone has an idea of CAB template/format. The company's requirenemnts is to track and report on tickets in their current review, approved/rejected/deferred. Status of in progress or completed. CAB takes place twise a week so the date of CAB is imprtant for historical purposes as well. It is not difficlut to create in…
COUNTIF formula with a date
Hello, I am new to this, this is probably a simple formula I am trying to use but I can't seem to make it work. (I have read through the forums and tried all sorts of suggetions that I have found).. I have a column that has a date field, and some rows have dates entered, some do not. I need to reference on a sperate sheet…
auto populate due dates
I want task due dates to auto populate based on one date that I enter as the event date. For example, I will set an event date and certain tasks will be due 2 weeks prior to event date. When I create individual event sheets, I want to enter that event date and then due dates will auto populate for each event based on that…
Automating swim lane changes in Card View
Does anyone know of a way to automate moving a card/task that has been set to 100% complete in the % completion data field into the "Complete" column / swim lane in the Card View (or for that matter, automating any swim lane change in the Card View based on any task data parameter)? Currently it's a manual process of…
Tip / Trick - DIY Help System / CMS
We are managing complex workflows that are fixed as templates into Smartsheet. A typical workflow may have >100 major steps each of which has a bunch of sub-steps, forms, scripts or limks associated with it. To manage this, we keep the Primary Sheet confined to the major steps and have it link to a Help Sheet that…
Selecting entire sheet for formatting
Is there any way to select an entire sheet for formatting? Thanks!