I am using the Event Registration template with Web Form template to register people for a number of volunteer events. I am using a SUMIF formula to count the number of people registered for each event. My problem is this: When I use a range of cells to indicate which cells should be counted, the Web Form puts the next…
s it possible to create a formula or a conditional formatting rule that would automatically highlight any child rows as they are created and/or based on a specific term or text in a column of the parent row?
I was updating my sheet yesterday and payed no attention but this morning I've noticed that all of the task names on the Gantt chart are gone and I can't seem to find a way to get them back. Any ideas? Thank you in advance!
Hi friends, I will try and explain what I am trying to achieve: I have an issue tracking sheet with columns effectively divided into 3 sections: 1) Originator raises an issue on a webform, on clicking "submit" the sheet is populated. This works fine. 2) A webform is then created from the cells in the row corresponding to…
I'm trying to figure out how to return the name of a child's Parent. Example: Parent 1 * Child 1 * Child 2 * Child 3 Parent 2 * Child 4 * Child 5 In the above, I would love to have a column on Row Child 1 that automatically returns "Parent 1" and for Child 4 returns "Parent 2". Is there a way to have a formula function…
Are these working for anyone? Seem to be down.
Hi Smartsheet Community! I have been looking for different help tips on How Tos, on using certain symbols and my search has been coming up very vague. I can't seem to find anything on how to use the Effort Symbols (The 1-5 people) and/or little in regards the uses of the directional symbols. I thought maybe I found…
Hi! I am trying to do a percentage of how many yes and how many nos I have in one column. I tried a couple of formulas and I am coming with some weird answers. For instance. =[Percentage of IPE Yes and No]1 - [Percentage of IPE Yes and No]2 / [Percentage of IPE Yes and No]1 and my answers comes out to be 4,773% I have also…
I am looking to connect a column in which I have a check box indicating done (check) and not done (unchecked). On the same sheet I have a column for Completion Date. I would like the sheet to auto-populate the Completion Date field each time a check box is checked as done. Is that possible?
Hi, I would like to know the formula for the due date of every month to calculate the receivables and Payables. For example, I have the data with amounts and due date of the payment. How can I input the formula, grab the amounts by the due date of every month. Please let me know.