-
hiding a column
the hide column option is greyed out. I am an editor for the sheet, and overall the sys admin for the account
-
Is there a way to validate that a particular cell cannot be left blank or allow junk entries?
In our application, we have the smartsheet as the user interface to enter the data and then this data gets transported into the database by an API according to a set cadence. For data integrity purposes, I want to ensure that certain key fields should not be left blank or allowed junk values.
-
Match Statement with Multiple Sheets
Hi, Due to the limited restraints on the # of rows (5,000) in Smartsheet - I need to create a formula that references multiple sheets for a match statement. See below: =IFERROR(IF(MATCH(([Employee ID]1 + [Current Position]1 + [Training Name]1), {Completions(1) Range 1}, 0) > 0, "YES", "NO"), "NO") I have another sheet…
-
Attachments Opening Multiple Times
I'm noticing an error today that I haven't seen before, and I'm wondering if others are seeing it. When I click one time on an attachment, it opens the document 2, 3 or 4 times. I'm certain that I'm only clicking on the attachment once. Anyone else seeing this?
-
Project Approval Received / Master Project Sheet Populated
I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, column values for new projects to be copied over to a master sheet, which includes additional columns for project charter and…
-
Report Builder not showing all column options
I've been trying to pull in some additional columns into a report from the same sheet that the other columns are pulling from. When I click on 'What?' in the Report Builder, it does not show all of the columns as options. They are columns with dates and are no different than other date columns that show up as options. I…
-
Material Tracking
Please help haha It is difficult to put into words exactly what I am trying to accomplish, but I'll do my best. Please ask questions if I'm not being clear enough. Example: I have a material column for material that is being delivered to a job site (Sheet name is Delivery Tracker). Each cell in the column is an individual…
-
Change color of task rollup bar
For groups of tasks, the overall heading bar for the group is always gray. I'd like to change it's color to signify status (red, green, yellow). Is this possible.
-
Free users can no longer use "send..." on a row
Hi, has something changed for free users with the send option at a row level? we have a number of admin users but also free users than will fill out details in a row and then click the row dropdown and select the "send..." to send a mail with the details filled out for that rown. Now when our basic (free) users select this…
-
Hiding rows
I would like to be able to hide rows can only find option of hiding columns. It would be especially helpful if hiding rows option could be added to conditional formatting.