-
Counting cards according to their status
Hi. I have four projects, each assigned to a unit division. Each project has tasks in different implementation stages. By default, Smartsheet counts how many tasks are in each stage (column). I want to use that counting to display in a dashboard, so I can see the status of tasks implementation by unit division in a single…
-
Roadmap for multiple selections
Hi Like the ability to add more than one contact to a cell, are there plans for the same with dropdown selections with being able to make multiple selections in a cell? Thanks Cheers Richard
-
setting up a user for the 2nd time
I am trying to set up a new user xxxx.xxxxx1@nhs.net, he was originally set up at xxxxx.xxxxx@nhs.net, but was deleted as he didn’t need it anymore. He now has a need to use Smartsheet again, but now has a new email address, which is the same but with a no 1 after this name. But when I put in the new email it comes up with…
-
Remove links from copied sheet?
I have a sheet that pulls some information from a master sheet using an INDEX/MATCH formula. Is there a way to make a copy of this sheet and retain the contents of the cells without the formulas? Basically, I want to make an archive of the current state without it updating in the future to new information if the master…
-
Image Sizing on Dashboard
Hello! Is there a way to eliminate the white space on an image widget? I've uploaded my logo and it came out very small and when I enlarge it only adds white space. Thanks!
-
Vlookup
Hello, i have a sheet with billed claims including a column "Pending Amount", and "Detail ID", each line item has a different detail ID, now i want to update the pending amount column according to another sheet, i tried the simple Linking Cell method but it did not imported the pending amounts to the right detail ID's. and…
-
Conditional Formatting - Comparing two columns
Please share with me your best advice. I am sharing an inventory report. If the low level is greater than the actual # of units we have, I want the column to be highlighted. While reviewing conditional formatting I do not see how I can compare the two columns to create the formatting. Each inventory item has a different…
-
Sheet Title in Alert Message
Hello Everyone, I'm trying to create an alert message that references the Sheet Title, so it doesn't have to be updated with each project. The attached image shows the default message title, which does include the sheet title, but I would like to change it to something like this: You have been assigned a new submittal…
-
Summarize data for graphing
Hi, I have a large data table used an experiment tracker, and I'd like to summarize columns to graph on the dashboard. The first column is a drop down list called vessel type, which has 12 different vessels. The second column is a drop down of pass, fail, and pending. I know I can use the COUNTIF to tally the number of…
-
Disclaimer
My office creates schedules for our customers which are intended to provide an overall estimate of time involved to ; but not a guarantee. We would like to include a conspicuous disclaimer or splash screen in some way to ensure that the intent is abundantly clear and the schedule is not mis-used. I have placed notes in…
