-
Error when opening a sheet
As I finished working on a sheet last night I got an error message saying to log off and back on. I logged off for the night and now we’re getting the same error message when trying to open the sheet. When we use the search feature it doesn’t appear. When we go to the folder it’s there, but we get the error message when…
-
Index Match Showing Incorrect Amounts - Formula when there is no information to pull
Hello! I am stuck on the INDEX MATCH pulling incorrect amounts when I reference another sheet. It will work for some cells, but not others. I am thinking since the parent sheet doesn't have all the line item costs for each store such as "Shelving" or "IT/LP", that could be the issue, but not all stores will have those…
-
Manpower Summation from Schedule
Hi! I have a construction schedule with the following column names: task, start date, end date, duration, assigned to, manpower. The "assigned to" column is different subcontractors such as "sheet metal subcontractor", "piping subcontractor" etc. My schedule is about 1500 lines long with lots of concurrent activities. My…
-
Cell Linking from a Form
Hello I am trying to do cell linking from when the information is entered in from a form rather than directly onto the sheet itself. When I do this it adds the information onto the sheet however it moves the cells I am trying to link down to the next row and will not transfer over the information. Is there a way I can do…
-
Report on all sheets I am part of as Assigned To
Many of our team members will be allocated to many different sheets. 1. Is there a feature how to make a report showing all sheets I am assigned to?, and as a continuation a report showing specific tasks in those projects, for example Gate Review, or Offer Submission? Those tasks are not necessarily assigned to that…
-
Virtual User Group Recording - March 24
If you missed our March 24 Construction Virtual User Group, no worries - we recorded it for you! Here is the agenda we covered: Customer Spotlight: Hear how fellow Smartsheet user Mike Vaughn, Project Coordinator at Edmonds Engineering, utilizes Smartsheet for project management and how he created a fee estimator project…
-
Trying to delete a large number of rows trough API
Hi I am using the Node JS SDK to delete the content from a sheet. It works fine but for a lot of rows it fails (I have tested with a minimun of 1000). I get an error that says that the request is to large for the server. I understand whats happening, but I was wondering if there is another way to clear a sheet using the…
-
How to create this COUNTIFS with AND/OR/NOT
I cannot figure out how to create this formula to get the metrics. I can get each individual dept metric correct using =IFERROR(COUNTIFS({(Phoenix) Project Tracker - Aerial Status}, AND(@cell <> "No", @cell <> "Complete"), {(Phoenix) Project Tracker - Status column}, AND(@cell = "Complete"), {(Phoenix) Project Tracker -…
-
One off Saturdays in Gantt
Hi all, I work in construction and use the gantt chart heavily to manage scheduling subs. I have a unique situation for my project where I may have to schedule work on a Saturday. Is there any way to allow a single Saturday, instead of opening Saturdays for the duration of project?
-
Jira Connector only allowing one project to one sheet
Hi, We have recently implemented the Jira connector for Smartsheet and this is working well in each sheet where we have a one to one relationship with Jira Projects. We have a single sheet which is collating all enhancement requests (using a web form as a front end) which will place enhancements into the relevant Project…
