-
Contact Support Page not working? Having cross-sheet formula issue
Two issues here: #1 - Anyone else having issues with the Contact Support Page? I keep filling out the form and it's going nowhere? No field errors either? It's been 2 days now with no luck so hopefully can get some help here. #2 - Cross sheet formula Issue i'm experiencing. I have 3 sheets - one is a data source sheet, the…
-
Search function not always working on iOS
Hi everyone, I created some new spreadsheets today, and while I'm able to use the search function fine on the computer, when I search the same thing on the mobile app I get no results. I'm still able to search many other sheets on mobile, but not the new ones that I created in the last hour. Is there a fix for this?…
-
Please bring back the tabs...
The new December 2018 look prevents easy navigation and inhibits work-flow. This is not a positive update. I see numerous posts expressing the same opinion. Please bring the tabs back or make them an option.
-
Template Workspace / Copy Row Automation
I am using Control Center to deploy projects. Inside the template are workflows that copy rows to another sheet inside the same template. When a new project is made I have to go edit all copy row workflows as they continue to point at the template and not point to the new sheets in the new project. Am I doing something…
-
Generate Bar Code and link to cells
can we generate barcodes of each equipment and with the help of bar code scanner, can it display the information of it with the the options to update the forms? I know we can update the forms but how can we display the informations from the sheet at the same time?
-
Restricting Access to Linked Attachments?
In a sheet that I created and shared with other users, does every user have access to be able to open/view attachments linked to some rows if the user I shared the sheet with doesn't have access to the document in the original application (ie, Dropbox)? If so, is there a way to restrict access to the sheet attachments for…
-
Average for both columns
I have a dropdown columns with several choices and each choice represents % complete. The idea is to get the Circuit % complete for 1st and 2nd circuits columns but also It has ‘N/A” that will not count. It only count the column that doesn’t have it. This is what I tried: =AVG(IF([1st Circuit Status]@row = "Assigned to…
-
Invalid Operation when using Today() in nested IF STATEMENT
Here is the formula I am working with: =IF(ISBLANK([Start Date]@row), " ", IF(ISBLANK([Actual Start Date]@row), "Not Started", IF(ISBLANK([Actual End Date]@row), "In Progress", IF([Actual End Date]@row > TODAY(), "In Progress", "Complete")))) When I have dates entered for Start Date, Actual Start Date, and End Date the…
-
Is it best to link only one predecessor to each task or is it ok to have multiple?
I am working on a construction schedule and wondering what the best practice is for attaching predecessors. I have noticed my Gantt chart is currently a bit all over the place and I am thinking it is because I have too many predecessors for each task. Do more experienced Smartsheet users recommend only having one…
-
Create Chart Widget Using a Report (not a Sheet)
With the Dashboards, I am able to create charts from a sheet but not from a report (this requires using the report widget). I collect weekly "submission date" data from 40+ people. I have created a report that shows when the submission is due, when it is submitted, and the number of days (plus or minus) between the two. I…
