-
grouping columns
I'm new with Smartsheet. I want to replace some of my work scope I'm doing currently with Excell by Smartsheet. For this I have two question: 1) Is it possible to group columns as you can in excel? 2) Is it possible to merge cells (horizontally)? Regards Chris Grouping in excel Merging in excel
-
Uncheck box when another cell is not empty
Hi everyone, hoping for some help with a particular workflow I have been struggling with. The short story is I'm hoping for a formula that unchecks a field when another cell is not empty. The longer story is: We use a checkbox that triggers a request for clarification from our customer. It sends them a form, with a cell…
-
Capture data in different columns
I would like to be able to separate the options of a multiple type column into different columns, for example, if a drop-down list with multiple selection "Texas", "New York", "North Carolina", "South Carolina" can be placed in the column ", then I would like to be able to have those three words recorded in different…
-
Dynamic links when copying a folder
Hello, I have a folder with several sheets and dashboards that I am using as a template set with whoever is starting a new project would copy the entire folder. One of the dashboards I have has several links to forms created in the sheets being used; is it possible for when the folder is copied to have the links in this…
-
How to display Today`s Date in Dashboard
Hello, I have a dashboard that I need to present today`s date. I created a Date sheet just for date with =TODAY(1) function, and used Metric Widget getting data from the sheet summary. However, when I check the date it is not updated. I had to open my date sheet for that particular date, and click save-only then the Metric…
-
Automating date columns
Hi, I've been digging in the forum for a while for this, apologies if I've missed it. I need to record a start & completion date for tasks and subtasks, in order to generate a duration. I've set up the columns as date only, and enabled dependencies in project settings. When I go to automate the start to record based on my…
-
Organizing data to display in a Dashboard Widget
I am working in a Dashboard trying to get a Bar Chart Widget to display data from a report the way I want it arranged and not in Ascending or Descending. I want the data to show in a non-alphabetical arrangement. I'm working with these items: Initiation Planning Execution Closeout Problem is they will not show on the…
-
Can I use a VLOOK within an if statement?
I want to use a VLOOK up put only if there is a balance in a column: =IF([Request Infrastructure]@row = 0, 0, VLOOKUP($Project@row, {2022 Nkhoma Hospital Project Plan Range 1}, 14, false)) If my Request Infrastructure is zero I want 0 to be in the Available Balance Infrastructure column, if it is a number I want to perform…
-
Is it possible to suspend all automations for a row based on status?
I have a SmartSheet with numerous automations based on the Status of the line item. One of the Status options is to put the project on hold. Is there any way to halt/suspend notifications and other automations if the status is on hold?
-
Updates not syncing with a GANTT chart to Google Calendar
Hi all - I have created a calendar in my Google account using the URL from the 'Publish to Calendar' function on my Smartsheet. However when I update my Smartsheet and save, it does not automatically update in the Google Calendar I have created. I've refreshed the calendar a few times but the new additions / updates to my…