-
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
-
Method of linking data from source sheet with an increasing number of rows
The function I am looking for would allow for data to be pulled from a source sheet which is increasing in size and be kept in sync for maintaining accurate information. To help explain, at the moment I can link an entire column of 'Engine numbers' with number n (approx 300) rows and the corresponding data with no problem.…
-
Linking Sheets
I am trying to link two sheets. The main sheet contains all my essential information, however one column has a list of drop down options. If the user selects a certain option from the drop down I want certain information to be presented in a separate sheet. E.g: If in sheet 1, monthly payments are selected from the drop…
-
Smart Sheet Freelancer Required
Seeking an independent Smart Sheet Consultant to begin work no later that the 31st October 2017 6:00 PM GMT You should be able to screen share and use our already uploaded excel spread sheets to create reports.and sights. You should be able to use the advanced functions of cell linking and formula to create forecasts.…
-
Auto-populate a value based on dropdown
I am trying to have a column with dropdown choices auto-populate a value in the next column. If IP-A is chosen in the AssetType column, the TotalHours column should display 1. If IP-D is chosen the TotalHours should display 15. I was thinking conditional formatting would work but it only formats text/background. Is this…
