-
Sharing Report to non-licensed users
HI, I am trying to share a report to users (not licensed) but can only get them to see the sheets in the report if I give them a license. I have shared the relevant sheets with the users. Before we signed up to the paid account this was an option. Thanks, David
-
Prevent Formula Overriding
Hi there! I have a column set up to indicate Task Progress (can choose from dropdown: Not Yet Started, In Progress, Nearing Completion, etc.) but also would like it to automatically mark "Complete" if another column (checkbox formatting) has a marked checkbox. The issue I'm having is that the formula erases if someone…
-
Limiting Auto Number to Specific Range
Hi, I'd like to add an auto number column, but I would like to set the specific range in numbers. For example, I need the auto numbers to be between 0 and 250 without duplicating. Is there a way to set those limits? Thanks. Jay Duque
-
Fill sheet based on another sheet (if cells contain value)
Hi Smartsheet community, I am looking for formulas or ways to automatically fill sheet B with the information of certain columns of sheet A for all rows in sheet A that contain a value. In a dynamic way, meaning if a row is added to sheet A it should be also added to sheet B. For example: - Sheet A has 1 column with 10…
-
Automatically Adding Rows Based on Change in Another Sheet
I would like to be able to automatically populate rows in a sheet based on the change in status in another sheet. For example, if I have a spreadsheet of jobs I'm bidding on that has a column with dropdown options of "Bidding", "Won", and "Lost", I would like to have a sheet that auto-populates a row in a different sheet…
-
Formula reference data exceeding 25k cells
Is there a way to increase formula reference data. The default restriction is 25k cells and i'm exceeding this
-
Auto-Lock All the Child Rows
Hi All I know how to lock a row when a certain condition (or a set thereof) is met. But is there a way that when a row gets auto-locked, all its child-rows also get locked automatically? In other words, some kind of inheritance mechanism. Thanks in advance! Nasir
-
Vlookup
I am using a this Vlookup formula =VLOOKUP([Capex APR# / Opex WBS]1, {array}, 4, false) This formula works ok and looks at data in the one sheet {array} due to the amount of data, two sheets are now required to be looked at by the formula how do I do this?
-
Ghost data from unused SCC template remains
I have three different gantts with some summary data that is fed into the main project data sheet. Only one of the gantt sheets is used in a project, so I thought of linking each of the gantts' data (exact same field/cell in each sheet) to a cell in the project data sheet - then just grab the one that isn't blank or an…
-
COUNTIFS for how many blank cells in a column, but only if another column has a populated cell
For our smartsheet we keep track of vehicles that are or are not repaired. To keep track of how many "open claims" we have I am trying to count how many blank cells we have in the column that signifies if something is complete, but when I try to just count those cells it counts the automatic additional rows on the bottom…
