Product questions?
Ask it here! The community's got your back.

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

Calendar Tasks to outlook for assigned tasks only
I published the iCal link to my outlook calendar, the problem is that every task on the Smartsheet shows on my calendar. We have around 15 people to whom tasks have been assigned. It would be great if we could link just their tasks to their calendar. Having all the tasks clogs up the calendar and is pretty much useless. I…
Changing Send To for Reports "send as attachement"
I have a report that I have on a delivery schedule. Over time I have had to add and delete names. Since the functionality doesn't allow you to easily change the sent to list for existing reports, I have had to delete and recreate "send as attachment" jobs. I know there is a way to manage a distribution list which is what I…
Counting Past Due Task on a Sheet
Hello, I'm trying to see if there is a way I can put a countifs function into a project plan template that will allow users to keep a rolling tally of any tasks not 100% complete and in the past. Ideally i would like this to only look at milestones (0 duration) as i'm going to collect this from every sheet and place on a…
Schedule tracking - SPI vs user perspective
Hi, The scheduling tracking feature in Smartsheet shows that Parent Task is ahead of schedule for below, with Today = 10-Sep-2018 Task From To Completion Parent 06-Aug-2018 21-Sep-2018 83% Task A 06-Aug-2018 10-Aug-2018 100% Task B 13-Aug-2018 17-Aug-2018 100% Task C 20-Aug-2018 24-Aug-2018 100% Task D 27-Aug-2018…
Reference the value of a cell that is obtained through a function
I have cell one that has a function in it say IF(1=1,true,false) and it outputs true. I then want to do a vlookup for that true value, but I keep getting that no such value exists. I assume that's because the cell actually contains the formula rather than the value true. Is there a way to reference just the outputted value?
Notification without changes in row or column
We have a sheet that track onboarding activity for new clients. Two date columns in the sheet are Follow-up Due and Follow-up Actual. I would like to send a notification or reminder to the assigned employee on the Follow-up due date if the Follow-up Actual is blank so they are only receiving notifications about open items.…
Collaborating on Single Task with Outside Vendor (Rehab)
Greetings. I have a Real Estate Property "Rehab Project Plan" with tasks that I would like to assign to a vendor (i.e Electrician) so that I can manage his tasks and collaborate with him. I do not want the Electrician to see entire sheet, only that task(s) assigned to him. I have read several articles on this but couldn't…
Best Way to Have a Back-and-Forth with Non-Users?
I have a sheet with info for a few hundred people. For privacy reasons I cannot share it with them, because they cannot view other people's rows (a selectively hidden feature I've put in a vote for). So I send everyone their information in an update request and ask them to fill it out. I then see their answer, respond, and…
Filters
We have created some filters in our production sheet but when we remove the filter the data does not return to its original order in the sheet. is there something we need to do or something we are missing to prevent this from happening?
Home Page Organization
I'm a new SmartSheet user and I think being able to order by the column names is a great feature. Are there any plans to add a feature to move items (sheets, reports, dashboards) up or down to customize the order of the sheets/reports/dashboards in your folders on the home page. Maybe just right clicking it brings up the…

Popular Tags

Trending in Smartsheet Basics

फोनपे गलत लेनदेन की शिकायत कैसे करें
फोनपे से पैसे कट जाने पर, ये कदम उठाए जा सकते ग्राहक सहायता से संपर्क(O76~071~42897) है पेटीएम ऐप में जाकर, “ट्रांज़ैक्शन” या “इतिहास” सेक्शन में जाएं. असफल लेन-देन चुनें. “वापस लें” या “वापस लेने के लिए अनुरोध करें” विकल्प चुनें…
मैं कुकू एफएम से शिकायत कैसे करूं?
कुकूएफएम मई को स्वचालित भुगतान रोकने के लिए, उनकी ग्राहक सेवा हेल्पलाइन नंबर O82998×84347 // संपर्क करें और ऑटो-पे को अक्षम करने का अनुरोध करें।✓
IF logic formula
Hello, need help. I created formular for two outputs - "OTD" or "Not". See attached snip for details: A) Test 2 and 3 with date = Correct outputs, but for b) Test 4 without date = Same fx, still output "OTD" doesn't make sense. What do I need to do? C) For Test 1 formular seems working. But I'd like to incorporate into one…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags