-
I am trying to find a value in a table based on 2 criteria.
I am trying to find a value in a table based on 2 criteria. One of the values is dynamic from a drop down menu, while the other is static value in a column. The first value is found in column "Building type" and the other is found in Resource type. The table I am referencing is also shown. The result would be shown in the…
-
Merged: Checkpoints to revert a change
This discussion has been merged.
-
Remove From Current Plan Before Inviting
Hello, I'm trying to add a user and receiving this error. When I first added this user, the status stated DECLINED. we think that it's because she deleted the email invite thinking it was sent accidentally. BEFORE THE ABOVE ERROR I tried to assign ALL roles to her and sent her the invite. She got this error message: Thats…
-
Merged: Retain cell history
This discussion has been merged.
-
Easier and shorter "If" formulas
Ability to select a value from one dropdown list, and then have a second dropdown list display only a limited number of options based on that first selection. Example: Column 1: Zip codes (user selects a zip code) Column 2: Flu vaccine dates (only the dates available for that selected zip code appear as options)
-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…
-
Possible to create multiple linked templates?
Hi All, Hoping there's a few Smartsheet super users out there that can help! I've created a pretty flash client specific dashboard which pulls in from one master project template, which is is also linked to about another 10 seperate report sheets. Without cloning and linking it all up again, I was wondering if there was a…
-
Is it possible to create a Template and share it to other users?
Hi, I have the following dilemma- I have created a really good PMO system within smartsheets using different sheets & dashboards, I would love to roll this out to other users within my organisation to utilise it as a template My question is, is this possible and if so how do I do it? For context I am a consultant and we…
-
Why sheet requires saving when nothing changed?
This happens on 2 of my 10 sheets, and only started happening a few weeks ago. The moment I mouse over the grid of my sheet, the disk save icon immediately goes blue (enabled), thus indicating that something changed on the sheet. Thus when I now click on another sheet, a dialog window prompts me to confirm to save my…
-
Status Log Push to Dashboard
I want to push the latest status log sheet entry to the dashboard. I have added working columns for the last date, recent value (0 or 1) and recent status (text field). The recent columns are blank except for the most recent data rows (that part of the sheet is working). I have a project metric sheet template across topics…