-
Registered vs. Licensed User
Hello! I would like to track the 'Created by' field on my web forms. In order to do that it requires that the "Accessible by" option the web form be set to 'A Registered Smartsheet user (requires login)' be selected. Can that user be a registered user but not a licensed user? Thank you!
-
Event Registration with Form & Summary
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…
-
Conditional Formatting or Formula?
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?
-
Task names in Gantt are gone
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!
-
Populating webforms with data from sheet
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…
-
Formula to return Parent name of child?
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…
-
Smartsheet Maps
Are these working for anyone? Seem to be down.
-
How to use the Effort (People) Symbols with Formula
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…
-
Possible Easy Percent Question
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…
-
Trying to connect a check box column to a completion date column
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?
