-
Linked Cells hindering form entries
Hi, Facing a problem with form entries on sheet with a bunch of empty linked cells. The webform entries go right to the bottom where the links end. The linked cells are important as plenty of info will be added to it in a single day and it becomes quite cumbersome to keep adding new links as we go. Is there a workaround…
-
Auto Number Columns Based on Other Column Input
Is it possible to link the auto number format to data in other columns? For instance, if the user selects a particular product type in a form (Soda, Water, Juice), can I create an auto number column format that looks like Soda-001 or Juice-001? Thanks
-
Linking Cells from Columns to Rows / Transpose Paste Special
I am trying to copy data from a source sheet to a destination sheet. The data on my source sheet is in columns, but I want it to be shown as rows on my destination sheet. I have tried to link several cells at a time, but it only links one cell - not the group of cells. So... I tried to bring in over as column to column and…
-
Suggestion: don't break cell links when moving row to another sheet
I'd like to make a suggestion - I just moved a few hundred rows of data with intricate cell links to another sheet using the "Move to Another Sheet..." option. All of my cell links were removed without warning. I would like to suggest that either the cell links are not removed during this action, OR a warning pops up to…
-
Project Management Best Practice Ideas?
Good Morning Smartsheet Community! Does anyone have any best practices / suggestions they could share for multi-project management ideas? We are currently using a Report that pulls rows from the "Assigned To" column across all project sheets in specific workspaces; However, while it serves the purpose, it isnt visually…
-
Form Field to Comments
Is there a way to have a field on my form that would input the text to the comments for that row?
-
if statement
Hello, I am trying to make an "if statement" but I got no luck. I don't know how to start, I tried with =IF(sqf1 > "32", "width1*hight1*5.5", "sqf1 < "32""width1*hight1*8.5") I know its looks bad :D Thank you
-
Automatic Address Finder
Does anyone know if smartsheet has a feature whereby the address can be located automatically by filling in the postcode on a UK Address similar to https://www.parcelforce.com/postcode-finder It would be great if someone knows an app that can be integrated into the platform/worksheet to allow for me to select the correct…
-
Linking from a sheet that's reached the 5000 row limit
Hello Folks, I’m relatively new to smartsheets (3 months) but I’m diving right in creating sheets for a medium size construction firm. My recent project is a daily time reporting sheet for approximately 100 field employees. My sheet is up and running and is being rolled out to a limited number of supervisors during the…
-
Checkbox Parent Cell if any Children cells are Checked
Hello, I am looking to use a formula that will check the box of the parent box if any of the children boxes in the same column are checked. Can anyone help with that? Thanks
