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 2015 Posts
Archives for September 2015
Discussion List
CountIF Children Overdue
Hi Team, I am trying to count how many of the child rows are overdue and am stuck on the syntax for the formula. This is what I currently have - =COUNTIF(CHILDREN([End Date]4), <TODAY()) - but I am getting a "unexpected operator" error.Can someone please advise how this should be written ?
QR CODE
Hello Samrtsheet Community! Just getting started with smartsheet. Is it possible to publish a sheet, embed it on a website...YES but then be able to create qr codes that would point to the particular matching row. For instance. If we manufacture a "widget" and each widget was unique and had a special serial number.…
Applying Existing Conditional Formatting from one sheet to another
Is there anyway to copy conditional formatting created into one sheet to another when the other sheet already exists with data without manually recreating?
smartsheet does not automatically refresh
After someone submits a form, I would expect my smartsheet to refresh so I can see the new row. That is not happening nor has it since I built this sheet. I have to manually refresh the page. That's not normal, is it? What do I do to make it update automatically? Thanks
Helpful Things I've Discovered About Smartsheet (Long)
I've been using Smartsheet for about 2.5 years now and gradually discovered how great it is for many tasks within a our small consulting company. While I originally started using Smartsheet for its project scheduling capabilities on large projects, I've ended up using it for much more. During that time I've discovered many…
Parent Rows as Milestones???
Is it possible to make a parent row a milestone as well?
Formatting
I have someone sharing their smartsheet with me but it is not translating their formatting to my view, what can I do? Thanks.
Subtask Dependencies Error Message "REF"
I am getting a "REF" message in the subtask cell for Predecessor column. For example: Line 3 Start SF, start date: 8/18/15; end date: 8/18/15 = I entered the number 2 Line 4 Update SF, start date: 8/19/15; end date:9/17/15 = I entered the number 3 Line 5 Review SF, start date: 8/19/15; end date: 9/16/15 = I entered the…
I would like to be able to create reusable templates for "Send Update Request" similar to the Form f
I routinely use the Send Update Request 20 to 30 times each month for updates on items we are tracking. This process gets repeated across several other teams as well. My request for "Send Update Request" all contain the same columns which takes time to fill out as the Smartsheets have 40 to 60 colums to search thru each…
Publish: Open to today's date
I want the Gantt to open to 'Today's Date' when published. I already have it set to do that upon login but the setting doesn't seem to carry over when published. Any help?