-
Release 2016-08-06 unintended consequences?
I logged out of all my Smartsheet logins last night prior to the update. I've been testing this morning and have been noticing odd refreshes. Sometimes this is not associated with a message. However, I have received these messages: I have checked (and am monitoring) my Internet connection but have seen nothing odd in Task…
-
IT Employee Change Documentation
Good morning everyone, I'm exploring new options to replace out existing, out-dated InfoPath form for employee IT changes in our organization. Right now we get an XML file sent to our helpdesk, financial staff, and office services, so we'd like to be to emulate that functionality, just with a better output file that our…
-
ATTACHING OUTLOOK EMAILS
Some of our users are finding it hard to look at emails that have been attached to a cell. they are able to download the email but then it turns up blank. Is there any way to get around this?
-
Auto Number stopped incrementing
Hi I have an auto-number field set on a sheet used for web forms, so that our forms have a reference number. Yesterday, it stopped incrementing, and all new lines were labelled as XXX807. Today, I manually set it to start at XXX808, and sent two test submissions, both arriving as XXX808. Has anyone experienced this? Thanks!
-
Links to external sites in a Report
I have a sheet with a column that includes a URL link to an external website. I have reports that include this column and I noticed that in the report the LINK is no longer a clickable link. I can double click on the cell and "see" and copy the URL but not click on it. Has anyone figured out a way to make the link an…
-
Auto-numbering not working anymore!
Hi, With the new update, the auto-numbering doesn't work anymore. I get the same numbers everytime with a new row. Please help!
-
Formula using both an IF and SUM(CHILDREN()) parts
Hello people I would like the cell in [Total]5 to show the sum of all its children, but only if the [Qty of Tasks]5 cell is empty. If [Qty of Tasks]5 is not empty, then I would like [Total]5 to show =SUM(Tender5 + Variation5) I have tried =IF([Qty of Tasks]5, "", =SUM(CHILDREN()), (Tender5 + Variation5) * [Qty of Tasks]5)…
-
SmartSheet Reporting Question
Does the report functionality have an option to only include new data adde? I have a sheet that will be populated over the next few weeks by a web form and I want to send weekly reports of just the data from that week. Thanks!
-
Use linked cells as part of a formula
I'm trying to port across a large database from Excel into Smartsheet to enable us to use the Kanban type activity flow. My excel sheet uses multiple tabs, and on one of these tabs I have an 'Analysis' section that pulls in data from all of these tabs and uses cell references from multiple tabs. Smartsheet (not using tabs)…
-
Function 'WORKDAY' returning #INVALID COLUMN VALUE when formula in different column
Hi, I seem to be having difficulty with something that should be so simple. I have two columns 'Date Required' and 'Decision Date'. 'Date Required' is a user input date field, 'Decision Required' is (or should be), an auto-calculated field to subtract 5 working days from the 'Date Required' field. The formula I have…
