-
Automatically add formula to new row & apply @row to look at row above
I have my cashflow forecast on Smartsheet, and i have a formula which looks at the balance on the row above to apply the balance for the current row as follows =BALANCE1350 + [in's]1351 - [out's]@row. When i shift the row up or down within the sheet, it keeps looking the the balance original balance on the row that was…
-
Register and calendar integration
Hi, I need assistance in creating a calendar which will show the number of locations where material deliveries will happen (5 locations) over 24 hours - 365 days a year. The idea is to then create a dashboard with the form and calendar and share it with the senior members of my team so that they can book delivery slots by…
-
Populate column with names by project
I'm wondering what the best way to do the following would be: I have about 100 districts and each one is assigned to one of four people. I want to populate a column with the names of the people associated with each district. Would this be best as a nested If statement? Thanks!
-
Form
I created a form some months ago and I need to expand it now by some columns, but the update just doesn't show for the user who is filling in the form. Can anybody help? Thanks!
-
Formula with multiple equations
I'm trying to convert a fairly simple formula from excel into one of sheets that has multiple equations in it and can't seem to find the one that works best. formula in excel would be =(B45*B46)+B45
-
Can I add something to color code for blank cells?
Hello, I am using the following formula to represent health color for individual rows: =IF([Start Date]40 > TODAY(), "Blue", IF(AND([% Complete]40 < 1, [End Date]40 < TODAY()), "Red", IF(COUNTIFS(CHILDREN(), "Red") > 0, "Yellow", "Green"))) This formula works well for what I need except that I use a template project sheet…
-
Applying Filter to Agenda
Hello all, I've been using Smartsheet for a few hours and i've been able to create in Gantt Mode without problem so far. The columns i've created allow me to filter tasks and help me read / correct / adjust the planning easily : Nice ! Now for the problem... The filters applied in Gantt Mode are effective in Agenda Mode…
-
Help with INDEX MATCH with duplicate unique identifiers
Hi Community, I am working with an INDEX MATCH formula to return content from another sheet; however, for each unique value, there are 4 duplicates. For example, an associate completed 4 learning events all attached to the same cohort name. Records are displayed as: Associate 123456, Cohort 1, Learning Event 1 Associate…
-
Live Data Search Feature Request
Good afternoon, Would it be possible to create a product that allows users to do a live search on sheets and even possibly aggregate data from multiple sheets to produce given search results. I have already built this through a customized application internally but users are asking to have this capability. Thanks, AJ
-
When saving as a Template do the shared filters carry into a new sheet created from the template?
I have tried this several times but the filters I create before saving as a template do not appear in the derived sheet. The check box above leads me to believe the filters should be in the template.
