-
Sheet populating answer not listed in form options
I created a form with several questions. One of them is a required question, with the only two options for answers being "Yes" or "No". Some of the responses I received have a "CA" listed in the field.
-
Auto-populate form responses from another sheet
Good morning! I currently have an intake form for basic requests for one of my departments. I also have a separate intake form for larger projects that need project management involved. What my ideal situation would be is that when the status on the Basic sheet changes to something like "Needs PM", it would have an…
-
How to populate duplicate numbers into sheet?
Hello, I have one main sheet that tracks all incoming DRR #'s and every row has a couple of names in it. I want to build another sheet that tracks names based on the DRR # but want it to populate in different rows, like below. So two people are on 0001 while in the main sheet that would only be one row
-
Allow editing of column type when conditional formatting is disabled
Currently, 'Column Type' can only be edited if it is not being used in a conditional formatting item. I understand there are probably computational limitations with the sheet trying to re-apply a format to an item type that no longer exists under a column that still exists (would probably crash/freeze), but the only…
-
UPPER formulas
Is there a way to set a formula so all text in the column or sheet is upper case even if someone enters it on a form in lower or title case?
-
Allow Gantt view to use Date columns with Column Formulas for Start/End
I'm kind of flabbergasted that this is not currently possible in a Sheet, and I'm struggling to explain to my users why. It is already possible to populate a Date column with a Column Formula and then convert it to a Cell Formula, and then use that column as the Start/End for Gantt view / Project Settings, so the issue is…
-
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!
-
Automatically Sort Rows in Sheets
As rows get added & cell values change, it would great if we could automatically sort them in the sheets themselves instead of having to set up reports. Adding the ability to do this in a workflow would be a fantastic addition. Right now we have to do it manually.
-
Can you use the TIME function to calculate the difference i.e. duration between values in 2 columns?
Hello, I've previously used the many pointers and guidance on the forums for coming up with solutions that help calculate time and duration between columns using a range of different helper columns.. I've never used the TIME function before, but I'm hoping I can use this to try and save having to add multiple helper…
-
Use Javascript in Bridge to efficiently import data from an API
Hi all - I'm excited to share a custom Javascript solution with my fellow Bridge users. I am not a Jscript coder - all credit for this goes to the awesome @Nathan Lloyd at Smartsheet - Large Enterprise Technical Sales Engineer, who gave me the basis for this script at ENGAGE 2022. Thank you Nathan! In this thread I'll…