-
Formulas per column
Hello, Smartsheet team: If I select a cell containing a formula, I know I can drag the little box in the right-hand corner downwards to apply the formula to more cells of the column. Unfortunately, I need to do this for 300,000 rows! Is there a shortcut that will apply a formula to the entire column, or to a selected part…
-
Dashboard information depending on a selection
Hi, I just began using Dashboards and I have a question I´ve not able to answer. I have a project portfolio and several projects. The project portfolio is a centralized Smartsheet and its related to all the individual project smartsheets. I´m trying to build a Dashboard where you can select one of the projects of the…
-
Determining duration in Hours:Minutes
Hey guys, I have read several posts with several workarounds for calculating a value between a Start Time and an End Time where the input and result need to be in HH:MM. I have an idea and a beginning: 1. I created two System Columns. [Start Time] as 'Created (Date)' and [End Time] as 'Modified (Date).' 2. I created a…
-
Send an Update Request at a Specific Time on a Specific Day
I have read several post regarding the ability to control an update request / timing. I have tried this multiple ways. 1) Created a Form - I struggled with the team picking the correct date (this was necessary). I setup a Outlook Calendar Reminder weekly so it would remind them at a specific time. When they submitted the…
-
Sharing a Folder
good Morning i have a workspace with 3 differen Folders. Is it possible to share each folder with differen people instead of settin all sharers at sheet level? Regards
-
merge cells
Hello everyone, Is there any way to merge cells in Smartsheet? Thank you in advance!
-
Hiding NULLs in imported dates
I am importing an Excel with some NULL dates. How do I display empty cells instead of NULL? Thanks!
-
Removing/Adding people/resources in card view
Hi there! I am seeking some advice on how to ensure that when you add someone in Grid view that they show up in card view as well. I am also needing some advice on how to remove someone who has nothing assigned to them from the "Assigned To" view in card view. Is this possible? Thanks in advance!
-
Importing Task Hierarchy from CSV file
We are looking to establish a daily import of our project portfolio into SS via a CSV file. When I look at the task import schema, I cannot see a way for SS to identify the parent and child relationships between the tasks. This means we cannot import nested tasks and the task hierarchy. Do you know if there is a field and…
-
Card View. Being able to display a lane by Checkbox.
Hi. I have a grid that has a primary column, a few other text/number columns and then 5 Checkbox columns. The primary column is used to identify a staff member, the few other columns are for misc. information and the checkbox columns are setup (5 in total) as the 5 days in a week (M-F). The grid and form works. I am trying…
