Hello - new to formulas & struggling to get one to work. I have two sheets: One with the values in column format (Payer CSS Responses by Initiative) - this was done so specific drop down options can b…
I am setting up as simple tracking of an annual communications plan and have a Platform of Engagement column with about 12 drop down platforms to select from. I want a formula to track the amount of e…
Hi, I have created a form for our clinical therapists to enter type of service or referral provided for particular clients each week. I want an automation that takes this data and lists services provi…
We're trying to determine how many hours we have scheduled in a month for a particular project based on the start and end date of the project. I can't quite figure out how to set the MAX/MIN without t…
Good Morning All, I am having with an issue matchhing data between two sheets based on certain criteria. 1st sheet is a list of form responses. I have a name of requestor column. I need to complete tw…
Hi, Here is a background on what my ask is: We track publications on Smartsheets and the publication activity column has the following drop-down options: Journal Article Meeting/ Conference Abstract/ …
Hello, I have a set of form responses where 350 colleagues have given their job level, and provided their 5 personal goals (in separate columns), and which of our organisational targets their goal ali…
Hi everyone. I am hoping you can help me. I am trying to average the time it takes individual case managers to complete a case between specific dates. The reference cells are {CM Text} in the main she…
How do you convert the first row to mirror the header row? The Smartsheet template that we are utilizing requires us to use the first row in all formulas to pull information appropriately. When we typ…
