-
Changes in column ...
hi there 1. is it possible (and how) to allow users to change values in a column of a sheet in a report. But i dont want to let them change other things in the data sheet behind. In best case they can't open the sheet because there may be columns which are not for their eyes. I have different users with the same issue.…
-
Change Column Name in Multiple Sheets
Is there a method to change column names in multiple sheets? (I'm aware of the impact on reports that include those sheets.) It is very labor-intensive to change the column names in multiple sheets, but that is how we work in the real world. Change, change, change. I've already updated the template, but wow what a pain to…
-
RISK - Projects
Does anyone use Smartsheet for Risk Assessments / Risk Management? If so, What template do you use and what is your process? I've found on the link below several templates for Risk Management. However; when I download the excel and import it into smartsheet, the functionality is lost.…
-
Question about tracking project budgets in Smartsheet
Hello all, I'm working on a task where I have multiple project budgets that we want to track in one sheet. I thought the best way to do this would be by using individual sheets and then running a report to include data from each sheet but our Finance department is asking for a way to do multiple jobs (projects) and…
-
Year over year with Year-to-date calculation
Id like to create a formula to calculate year to date 2016 vs 2017 Example 2016 - I have total of monthly sales for all 12 months (jan-dec) 2017 I YTD have sales for Jan- march I want to look at Jan-march ytd 2016/vs 2017 % change year over year Thanks for any help! Tina
-
Resource Views - "Other Sheets"
Is there a way for anyone to identify the source of "Other Sheets" in within the resource view? There seems to be one or more sheets within my organization that have arbitrary allocations assigned which is deterring adoption of this particular feature.
-
Web Forms
Hi Is it possible to have additional lines appear conditional on a specific answer (tickbox checked) I'd like 3 additional questions if the box is ticked. If not then I can add the questions, but will add 150 lines to my Web Form and makes it rather long.
-
how to prevent a web form resubmission?
Is there a way to prevent a public web form to be resubmitted "n" times by the same person/user?
-
Need formula to count rows with a text character in a number string, within a date range
I would like to write a formula to count how many times a text character appears in a number string, within a specific week of the year. My JOB # column contains many project numbers (63254C, 63255C, 3235M, 63256C, 3236M... etc.). I would like to know how many "C" characters I have in that column, and how many "M"…
-
Calendar View
New to Smartsheets but I've created individual project sheets and I've taken key production data, specifically dates and linked them to a Master Production Schedule sheet. I've added the customer name as the parent and each stage of production as a child which allows me to see customer names and all of the steps in…