-
Portal/Report that can update based on filter applied
Hi I am trying to create a report/portal whereby i can create a page that can show me information from 2 sheets. We have a recruitment process and I want to be able to show a page which has the following information: * Employee details (pulled from sheet A) * All the positions the person has applied for (pulled from sheet…
-
Tracking comments on reports?
Can comments on sheets or rows in sheet be pulled into a report? I'd like to see the most recent comments added to a sheet on a report of several sheets.
-
creating row report & summary report from 1 sheet
I love the new summary report option but I still want to be able to create a row report from the same sheet. I have already created a summary report but I also need to add a row report to my dashboard for the same sheet. I used the summary report to create a chart on my dashboard. I tried to create a row report but the…
-
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…
