Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Reporting by contact
Hi, why does my report keep duplicating the contact? The only way I can fix it is if I delete the contact, save and re-add them and then save again.
Answers
-
Check if the contact is part of your AD (active directory) and also explicitly added to the list of contacts (which typically do not have email associated with it) in the column property. If you do see the contacts added to the list in the column properties then remove those.
-
How do I find the active directory?
There is nothing the column properties. Do I need to add them here?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.6K Get Help
- 434 Global Discussions
- 153 Industry Talk
- 495 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I have a column that is a contact list where a single or multiple staff members can be selected to be scheduled. I'm trying to create a formula that counts how many times each individual's names are l…
- I have two columns I am using for this formula: "Date Received" and "Days Duration (Received to Listed)". I want the formula below to look at any items in the Date Received column between 1/1/25 and 1…
- Hello, I am trying to create a report or calendar sheet with these weekly rotating roles: Weekly 1st shift Call Center (Mon-Sun) Weekly 2nd shift Call Center (Mon-Sun) Weekend On-Call 1 (Sat-Sun) Week…