-
Help needed counting across sheets
Hi all, I am trying to use the count of a symbol across some sheets. I know I can get this information by creating a report but for a more visual presentation, I am looking to get an actual number. I am currently trying something like this but it's not working: =COUNTIFS({sheet 1 Range 1}, 1, {Sheet 2 Range 2}, 1) The…
-
auto fill / populate cells
I am tying to automate some cells in smart sheet, for example If I put in an emplyees name in a column cell then I would like to have next column cell automaticaly fill in their phone number, next column cell will put in their email etc. Thank you for any help. SM
-
Non People resource assignment
Hi Hoe do I assign non people resources to a task. e.g. a piece special equipment to do a job so that I can see the utilisation of the equipment.
-
Custom colours in Dashboard Charts
Is it possible to add your own custom colours to charts in Dashboards so i can produce charts in my companies branded colours?
-
AIA G703 - Form Template
I’ve created a modified version of the AIA G703 form in Smartsheet for use in monthly tracking of my financing of a land development project. Each time a new funding request is made, a new sheet is submitted which includes a colum for “work previously completed” which needs to sum several columns from the previous funding…
-
Doing by date and not by task
We are a Habitat for Humanity affiliate. We do a group of different tasks on each day we build. Can I have a task for the days such as Day One, Day Two, Day Three and so on and make that the predecessor for the different tasks done on that day. If not how do I do it.
-
How to show more than one month on calendar view
I am wondering if there is a way to show more than one month on calendar view. I am working creating an HR sheet and I need to be able to see the last 12 months if someone took a vacation. Also is there a way in a column to have more than 1 date so for example if someone took off both June 5th and then July 8 can we put…
-
Update VIA API not showing updates
Hello There Super Noob to Smartsheet APIs. I am updating smartsheet, with Powershell, a Test Sheet sending simple sample data. It shows that I have added multiple row, in the test sheet, but it isn't showing the data even if I refresh the sheet. I have no Idea whats going on.
-
Summing children rows without double counting parents
Hello friends- I am creating a spreadsheet to help track project financials for a specific grant that the non-profit which I work for received. Specifically in the Summary Table, I have a sumifs formula which grabs specific line items based on the date and which installment of the grant they are using. I believe that the…
-
Sub-task card lane driven my main card
I am using card view as a materials log and I have a question regarding the 'grouping' of cards. The problem: We have a pallet containing 4 boxes. The pallet is assigned to a lane in the sheet. I have created a sub-task card for each box on the pallet. When I move the pallet card the sub-task cards remain in the lane. The…