-
Sheet Data Reports
Hello SmartSheet community! We've been using Smartsheet for a while now throughout our company and so far have several sheets. Some have important deadlines/dates while some just have to-do lists with several tasks that are flagged as important. I'm having difficulty figuring out how to compile all of the upcoming dates,…
-
#DIVIDE BY ZERO - Return Blank Value
Hello, I have read about the IF formula, but am having difficulty applying to cells in question. I am still trying to have #DIVIDE BY ZERO return a null value when other fields are not yet populated. Any support would be greatly appreciated! Screenshot: https://ibb.co/g8PBn7 The idea is that when # of Products is blank…
-
More than one contact in the contact list drop-down
We have a column type "contact list" that we use to track sales reps for individual products. Sometimes we have a product with more than one sales rep. I created a group with both sales reps as part of the group thinking I could use the group as the contact. It isn't available in the dropdown, only individuals. I want to…
-
Facilities Maintenance Plan
Hi, Does anyone use SS for their facilities maintenance planning and tracking? If so, I would be interested in touching base. We are putting together a multi-year facilities maintenance program in SS and any help would be appreciated. Thank you, Archie Lopez
-
Include update request button on Alerts
Hello, Is there a way to include the update request on an email alert? We currently send our customers a notifications when they submit a request. What we would like to do is give the customer the ability to update the request without giving them access to the sheet. We also do not want to manually send an update request…
-
Bring in data from multiple sheets
Hi, I'm fairly new to Smartsheet so apologies if this is obvious. I am essentially trying to bring information from 2 sheets which I can then edit or work on. Some background.. We have a sheet which details resourcing for ongoing projects (backlog) and another which contains information on the pipeline. The backlog gives…
-
Creating Master sheet
Dear All, I am currently looking at three different projects. I need to create a master sheet with the module, WBS and the Deliverables from each of these projects into one master project sheet. I tried the Report feature but it did not work. Can I please request you to send me some suggestions on how the same can be done.…
-
Is there a way to NOT auto number the 1st Row? ...and other SUM row questions.
I am using the first row for totals and it is throwing my auto numbering system off. Is there a way to have the auto number start on row 2? Alternatively, if I put my totals on the last row, the web form will populate new rows below my totals. What are some best practices to display my column totals on a continuously…
-
Formulas to durations or equivalent
I am building a production scheduler with a built in calculator where by the operator can adjust the labour allocation to test the duration output. My problem is Smartsheet won't allow durations to be edited by way of a formula. Also I am wanting the variables to be as follows: Completion Date - Constant (fixed) Variable…
-
Clock Hour Progress Management
Hello, My name is James Smith. I am an Instructor for Gateway Community College in Phoenix, AZ. I am Looking for alternative methods to track time as student’s progress through our courses. I am not looking for a time management system, just a tool to enter a student’s hours into a spreadsheet or software to help me manage…