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.

Consolidating several smart sheets in one (appending columns)
Hi. I have several smart sheets with 2 columns, being the first column common to all. What is required is to have an aggregated smartsheet with the common first column and append the second columns of the other smart sheets. I.E Smarthsheet 1 Subject Juan math A physics B Smartsheet 2 Subject Peter math A- physics C…
Vlookup formulae linkage across sheet
Hello, I have been trying to link my source sheet(A) with another sheet (B) as B is the base of my dashboard wherein I had inserted all the formulae for dashboard creation to display real time changes. How do I link my sheet B with Sheet A ? As all the changes are being made in sheet A, I want those changes to be…
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…

Popular Tags

Trending in Smartsheet Basics

Is there a way to have a form update existing information?
We are conducting an audit of our I-9s. In order to do so, we have pulled an active list of all of our employees (EEs). These EE names are already on the sheet. In order to effectively complete the audit, there are specific things we need to check for based on the expiration date of the I-9 document that we have on file.…
Pulling info from Reference Sheet based on Date
Hello, I am trying to pull the information I need based on a date on the referenced sheet. Without this criteria the formula works great. this one criteria is not working. I created a helper column on each sheet. on the reference sheet is a formula to calculate the month number for that row, and then on main sheet is a…
Need help with Data/Chart Widget
I am working on a dashboard with various data points and had zero issues until I started the most recent widget. I am pulling from a simple report that has a list of staff members and their assigned work spaces. I keep getting an error that says the data cannot be charted… What is the limitation here? I made 4 other…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags