嗨,我是导师和学员匹配工作。我们would like to match them based on attributes they both selected in a multi select column. As in, choose your top three competencies. Now I would like to make a formula to determine the percent match of a mentee to a mentor's selection. That is Mentee 1 selected A, B, and C.…
Hi, I'm working on form entry for a survey and I'd like them to rate in a star system. I'm able to change the column type to symbol with stars, but in the form the selection is word based (one, two, three, etc) instead of star selections. Is it possible to make this change? Thanks, Liz
Hi, I'm working on fairly large sheets that reference many other sheets. My main summary sheet is doing SUMIFS formulas to summarize and sum to a higher level. The summary sheet column is showing a Circular Reference error. I found the error on my raw sheet and corrected. However the main summary file still shows a…
I'm working on developing master sheets for my group that other researchers will link to. They will use this information to inform capacity and resources. How do I ensure that if I've added a row to the master sheets that it automatically updates their sheets?
