Hi, I am the primary column id. I want to iterate over rows and get cellvalues of the primary col in python. for MyRow in my_sheet.rows: After this is there any direct function to get the cell value u…
Hi, I'm trying to schedule 2 dates form the same line into a calendar. For example. Each time we sell a job, the job has a Part A installation, and a Part B installation. With this the line would have…
I have a master spreadsheet that details the progress of a project. I'm in the process of rolling all the information on that sheet into another that consolidates anywhere from 1-100 lines (check boxe…
Can't figure this out.. I have form with 4 fields in it. The user picks drop downs off of each of the 4 questions and saves the form. In the sheet, I have a 5th column that concatenates all of the 4 f…
Is it possible to link a drop down list to a query from another sheet column. For example It would be great to be able to have users select items from a list of the top ten sold items. This list would…
Here is the deal. I run a wedding video studio. I just made a smartsheet questionnaire (form) to have all of our videographers answer from the smartsheet app on their phones at the end of the shoot to…
Hi all, Been searching on the community but could not find an answer to my issue. Sorry if i missed it. So i have a Master sheet for the sales team, with all the customers to contact, with one rep all…
Hi everyone.. I am new to the community..so hopefully my question is not too stupid :D I am currently using Excel to calculate a value by using the normal distribution formula. I would like to pull th…
Please help! I was curious if there is a formula that would copy a row to another sheet, only if a certain column meets the criteria. I created two sheets that are exactly the same, but one is named O…
Hi Many thanks in advance to start! For each row i have a listed task with a column called Period 1 with a date and a checkbox next to it than when checked marks the date green. Each date represents w…
