-
HELP with a large sheet and table layout/conditional formatting
I spent 15 hours trying to organize my data in an efficient way and just can't come up with a good solution. Smartsheet is great but SO limiting if you are used to Excel. I have 200+ sites that each has 31 activities. Each activity has 3 dates - planned date, reforecasted date and actual end date. I need a report that…
-
ABSOLUTE CELL LINKING
Im really struggling with getting an absolute cell value to stay in a sheet or in a sheet summary. maybe im going at in the wrong direction. please help. I have a form on my call centre data sheet that is adding an information line each day. The line is picking up all my formulas for my metrics on who is answering the…
-
Counting open tickets based on company name and ticket status
Hi, I'm trying to count the number of open tickets by company name, and the cells I'm referencing are in another sheet. Here's my formula so far: =IF({Maintenance tracking Sheet Range 2} = [Company Name]@row, COUNTIF({Maintenance tracking Sheet Range 3}, {Maintenance tracking Sheet Range 3} = "Open")) But I'm getting an…
-
Using VLOOKUP for Approval Requests Across Sheets
GOAL: 1) Have a secure and error-free VLOOKUP on Sheet B and 2) Run a multi-level approval request automation on Sheet B. DETAILS: I have 2 sheets. Sheet A tracks contracts. It has columns for individuals (contacts) who are designated approvers for changes on contracts. Sheet B tracks providers named on the contracts to…
-
Copying Workspaces with Dashboards
We have a workspace with several sheets and dashboards. We want to copy this workspace for each incident we activate for. Is there a way to have the links within each dashboard automatically update to the workspace/sheet location? Currently we have to go into each dashboard and update the links - very tedious. We are using…
-
Combining cells from one sheet into a single cell on another sheet
I have a master spreadsheet with many columns (sheet1). From that, I want to create a second sheet with fewer columns (sheet2). The first column in sheet1 is 3 cells combined (=[Column1]1 + "-" + [Column2]1 + "-" + [Column3]1). In sheet2 I only need the info from Column2 and Column3. Is there any way to do this from a…
-
Cell values export from one project to another
Hello, We are currently managing a construction project with smartsheet and have created a Gantt Diagram and a few Dashboard to monitor several KPIs. The dashboards are updated automatically with every changes in the master project and provide up-to-date information during meeting. I would like to add curves to the…
-
Using a nested HAS formula within a COUNTM?
Hi there! For the life of me I can't figure out this formula! So here is the scenario. I have a grid with a dropdown multi-select column type with different organizational shared service options (e.g. Knowledge Sharing, Project Management, IT, Applied Learning). On a separate grid, I am trying to identify the number of…
-
Update cells via form or secondary sheet?
I have a sheet of contracts with 30 columns (status/progression/etc). The columns are updated by different people in different departments. Is there anyway to create a form that would have a dropdown of the contract ID and then the cells I need updated? If that isn't possible... Is there a way to make an automatically…
-
How to pick the latest date from Table 1 and enter it to the cell of Table 2?
Table 1 is a list of products that contains among others columns Trade Name, Country, Crop and Last Modified (Auto). Within the rows, one trade name can refer to different countries or crops. In Table 2 there are only Trade Name and Date columns. I need to choose the latest date from the rows of Table 1 referred to the…
