I am trying to create a formula on a sheet summary that returns the information in my row titled Total that corresponds with the most recent date within a specified year. I came up with the following …
I have looked at multiple questions and threads on the community and not found an answer that works. I am trying to create a column formula that pulls the [Balance] from the previous row into the curr…
Hello I have 2 sheets a master sheet and a sheet that is populated from a form. the first few columns on the master sheet are filled in via form, that data is then used for estimation which is filled …
I'm using an IFERROR formula with INDEX MATCH to pull names from two separate sheets, both of which use a contact list column type. However, for some entries, I get a contact list icon (with the email…
I am in Victoria, Australia and I am using a form to populate a sheet. I want to automatically populate the Inspection Date to be the date the row was created. I am using the formula =created@row The …
Hi, I have a Crew list sheet for Sports TV Production. I have the positions listed in one column, and a column for the Crew Names for Game 1, Game 2, Game 3 and game 4. I need to identify duplicate en…
I am trying to set up a metric sheet that pulls from helper columns on a sheet. The helper columns are set up to count values in a multivalued drop down list. I am want to use the date (specifically t…
Hi, My team currently works off a Smartsheet that tracks task e-mails we receive. Recently, we've been receiving a lot of duplicate items in our e-mail that we categorize with Task Subcategory "(TE) C…
We have a form set up for collecting information from scientists performing runs by different projects. We need to be able to supply material lot information to clients separately by project numbers. …
