-
IF statement to pull value from another sheet if a checkbox is ticked
Hi all, I'm trying to have a link between a risk register into an issues register and I don't know if it's simply my code or if this isn't possible in smart sheets. I have a column in my risk register with a checkbox that gets ticked when a risk has become an issue. I want my issue register to have a column listing the…
-
Auto Lock columns or rows through formula
I want to know if it's possible to create a conditional formula (or something like that) that as a result Lock the row or the column. When the user's filled the entire row I want to lock it from other changes, automatically.
-
Smartsheet in Commercial Real Estate
My team is working on incorporating smartsheet for our landlord and tenant rep clients, as well as our team. Any suggestions on best templates, etc to use?
-
Report vertically versus horizontal
I'm setting up a new tracking sheet which will have multiple columns (about 50). For ease of displaying these to end users, I would like to 'report' them vertically. Is that possible in SmartSheets? FYI, the reason for now setting up vertically is to preserve field format (date versus text). For Example: Currently displays…
-
Want sum calculation in report - Formulas in reports?
Does anyone know if there is a way to add a formula for a report? What I want to do is sum the values of a column for all rows returned for a report and to add some sort of highlight when the sum exceed a certain value. Specifically, if the amount of hours for a list of tasks for day assigned to a given person exceeds…
-
Help with Formulas
Hello! I’ve been using Smartsheets for a while now, but am new to building them. I am having trouble working with formulas to identify current status of my tasks. I’ve searched the community and have tried out suggestions based on previous responses, but I’m still stuck. I’d be grateful for help sorting out the following:…
-
Working Days and Holidays for different Resources
Current project settings allow to set-up working/non-working days and length of day in hours globally per project (see screenshot) We have teams from different continents and countries (US, India, China, Germany etc) working on the same project. It would be good to have an ability to set-up working/non-working days and…
-
6 Teams- 1 Dashboard Help
I'm trying to find the best/easiest way to display data from a Sheet Summary Report into a visual Dashboard. We have 6 different project teams, each with multiple tasks or projects with criteria we need to report on as a whole. I've summarized each sheet to give me the specific metrics I need, but now I need to get that…
-
Card View in Reports
Is it possible to have Card View in reports? It would be great to be able to see a card view board for multiple sheets at once.
-
Publish sheet in multiple views?
I'd like to show a sheet in the dashboard in both: 1. Grid view 2. Calendar view WHen I publish the link to put on the dashboard, it only one or the other. Please tell me there's a way to publish in multiple formats!