-
Is it possible to copy an automation workflow from one sheet to another sheet?
I have an automation workflow in one sheet that I want to use in a different sheet. Is there a way to copy this workflow and then add it to my other sheet (similar to how you can copy summary reports from sheet to sheet)? Or do I need to manually set up the workflow on my new sheet. Thanks!
-
How do I fix a VLOOKUP problem?
Hi there I'm using a form to capture COVID RA Test results, scheduled for different departments on different days. The schedule uses a VLOOKUP to populate the 'test result' column from the form results and allows us to report on anyone who was scheduled to submit a test by a certain time but hasn't (report if blank &…
-
Email validation for Forms or Workflow conditions
Is there a way to do email address validation in Smartsheet forms or in Workflows? Using condtions such as contains '@' or '@domain.com' isn't sufficient and I can't alert form submitters that they did not submit to the form correctly.
-
Capacity vs Demand Utilisation RAG Column
Hello, I'm looking to create a capacity vs demand utilisation RAG Column where it will appear with Red, Amber, Green for the following rules: Green: Total Q1 Capacity = Q1 Total Demand Yellow: Total Q1 Capacity > Q1 Total Demand Red: Q1Total Capacity < Q1 Total Demand Kind Regards, Luke
-
How to identify the first date and last date from another smartsheet column?
I need to identify the following: Smartsheet 1, Column Start Date, row 1 cell 1 and Column End Date, row 1 cell 2 (need to obtain from smartsheet 2) Smartsheet 2, Column Start Date and Column End Date have several dates. Smartsheet 1 needs to identify the earliest Start Date and the latest End Date from these two columns…
-
Can you group columns?
I have a very large Smartsheet that contains contact info, partners, dates for various deliverables, financials, etc. I'm wondering if there is a way to group columns that reference similar tasks thereby make moving around the sheet a little more efficient? For example there are 14 columns that pertain to permitting, 5…
-
Issue using COUNTIF function with OR condition where OR is reference to different sheet
I am trying to use COUNTIF function with OR condition where the OR is referencing to different sheet. It’s the OR that's causing me issues. When I refer to same sheet reference its working fine but when I use different sheet reference I get “#Invalid Operation” error. Formula that I am using is =COUNTIFS({Primary_Owner},…
-
Want to count number of instances in a column
HI There, I have one column in which I track the status of each row with a traffic light (Red, Yellow, Green). I would like to count the number of Red's, Yellow's and Green's in the column so I can use this information in a dashboard/portal to show the number of each color/status. I have triied a few things, but I am…
-
Printable and Readable A3 Gantt Chart
Hello, Could anyone advise on how to print a readable gantt chart in A3 format? I've managed to export it to PDF and select the rows needed, however it is barely legible. Exporting to excel has not helped as it deletes the gantt format. Would be grateful for any tips or solutions! Thanks
-
List of date formula I have used repeatedly
Doing this so I have an ongoing list of functioning optimized formulas , keeping it in the community in case it helps someone else. Please feel free to comment with your own, but I'm keeping the most basic of the formulas out of this. Below are just some of the ones that I thought of now, i'll comment more as I use them.…
