-
Preventing Editors from Deleting/Reordering Rows
I need some users to have Editor access to be able to enter data into the sheet, but aside from training and a clear job aid, I want them to not delete rows or sort rows. I have a column that generates a unique code for a course in a term. The first course entered for that term has a code that ends with 01 (e.g., NC60001),…
-
IF((CONTAINS)) function
I'm trying to verify that the emails in a column have the correct spelling. I'm using an IF((CONTAINS)) function, but it's not working =IF(CONTAINS("@kintegra .org", EMAIL@row ), "", "Check eMail")
-
Health Ripple Effect Formula
On my project plans, I use a Red/Yellow/Green/Gray column called [Health], and I also use the stock [Predecessors] column. I'm trying to come up with a column formula so that if I change the [Health] value on a given row, it will update the [Health]@row value of every row downstream that directly or indirectly uses the…
-
Formulas
If you have different numbers per line in the barcode column, you can see which product it actually is from these numbers. For example, 9040005530102: from the first two digits, you know that this product is DIM90. In the same barcode column, after scanning, you may also see other numbers such as 10040005590117, which is…
-
Organisational-Level Dashboard Placement in Multi-Tier Control Center Setup
Good afternoon, I am currently configuring Smartsheet for the organisation and have implemented a multi-tier Blueprint solution within Control Center. At a high level, the configuration includes two Blueprints: One Blueprint to provision Business Units (BUs), and A second Blueprint to provision Business Unit Projects.…
-
Can Smartsheet add SUMIF statements together? Struggling!
Hi all - I have successfully created a column with two cross-sheet references. The Concatenate Row adds the brokers name and the MM - YYYY. =SUMIF({Invoices Range - Broker 1}, Concatenate@row , {Invoices - Rev to Broker 1}) I want to add multiple SUMIF formulas together here is the formula I tried and getting error message…
-
Printing a Gantt Sheet
Hello I would like to suggest if there is a way to have the columns print the same in a gantt sheet as a grid. For example, when I change the sizes (smaller or larger) of some of the columns and then export the Gantt sheet to print- it changes the sizing for printing. I look forward to seeing this change. Thank you!
-
Why is my font changing when I generate a document?
I have a sheet that generates a document upon addition of a row. Occasionally the font in a field changes to a font that is different from what I set up in the editable PDF in Adobe. Here's what I've done so far: -used Adobe to "prepare a form" and set the font type and size for each field -not used an unsupported font (it…
-
Automation is ignoring conditions?
We've created what I think should be a pretty simple automation to copy a row to another sheet any time that it changes, based on certain conditions. If the project status is one to two options, and it the "trackable" column is checked. When I run the automation, it copies every single row over to the destination sheet,…
-
Access after not logging in for a while
If someone in the free version of Smartsheets does not log in or access the system in a certain amount of time, does their access expire? Our company pays for Smartsheets, but we have external users that are using the free version to review. One was OOO for a period of time and it appears she was no longer able to access…