Sign in to join the conversation:
Is there a way to populate formula in columns if multiple rows of data when pasting several rows to the columns next to formula column?
I would be willing to use CTRL +D, but it does not work in either of three browsers I have.
Can you provide more detail or some examples of what you are trying to do?
Thank you for your response. I actually observed interesting behavior. two columns that have formulas got populated properly when column next to them is populated with text/number, but were not populating before, when date column was next to them. I will keep watching if I can figure out other cases when it it or is not populated.
Hi, I’m using Smartsheet with a Master Sheet(All over Projects Basic Summary) and Individual project sheets that have multiple phases. When I change the Assigned Person in the Master Sheet, I want: •It to update only phases that are Not Started or In Progress •It should not change phases that are Completed Is this…
I created a master sheet that will list all projects for a department. We will also have a planning sheet for each project in the master sheet, created by copying one of four templates (based on the project type). Each of the four templates will have columns set up and a hierarchy of rows based on phases, workstreams,…
I need assistance with creating a calculation. I have a list of people on one sheet that has their names and rate of pay. The person fills in a form and enters their hours (form is the Contractor Pay Summary sheet). I need the one sheet to look at the other and pull in the rate of pay for each user. Contractor Sheet This…
