I have a dashboard that references a cell in a sheet. That cell contains a formula that displays a value based on date triggers (future, open, past due). My problem is the cell value will only update if I open the sheet and then click s…
Using Smartsheet7Ken Hallaran
I have a person creating Eloqua emails upon request. The requester fills a form with instructions and attachments of the email body. The email body will be sent back and forth for edits between the requester and the person creating the ema…
Using Smartsheet10Laura Tabellini
I have a project plan with tasks and planned start/finish and actual start/finish
How can I visualize them with two comparing gantt bars? Planned vs. actual?
Using Smartsheet26Joachim Mund
A person shared to a sheet (access level Editor - cannot share) is not seeing a parent row:
What it should look like:
(Image) What it looks like for this particular user:
Using Smartsheet12Jessy Martin
We need to publish / share dashboard to all (unlicensed) users in domain xxxx.com, without requiring them to set up an account / request a license. Anyway to do this? Thanks in advance...
Attempting to collect data, from multiple offices across the globe, to show how many locations a company has in various countries. Currently, there are 256 countries and roughly 5 "details" fields. We were hoping to be able to …
Using Smartsheet11Jessica King
I was hoping there would be a way to add dividers in my dashboard. Sharing the dashboard with our ELT, it could be easier to separate categories with line dividers that take up 1 square.
Using Smartsheet23Paige Borchardt
I need help creating (2) condition in conditional formatting or a formulas that turns do the following;
highlight all rows that are are between 3 and 5 days in the future from today's date
highlight all rows that are more than 5 days in th…
I have a selection dropdown for a Contact List in a form. Is there a way to automatically update that dropdown contact list rather than manually adding and removing people as they leave or join my organization?
I want to try to update con…
Using Smartsheet8Christopher Loh
I see that this topic was open last year, but the thread was closed quoting a workaround--add the duration column to the report and have users modify it to get the desired end date. My project plans need dependencies enabled but I also ne…
Using Smartsheet14Niyati Kumar
I'm trying to create Summary Reports but only ever receive the created date/name, modified date/name and sheet name columns to select from to add to the report. I've tried saving and going back in but no luck. The sheets I'm selecting all …
Using Smartsheet9Tamara Diver
I have 3 columns - Monthly Budget, Budget YTD and Total Spent YTD.
I want any cells in the 'Total Spent YTD' column that are greater than the adjacent cells in the 'Budget YTD' column to highlight in a different colour. I don't seem to be …
May I ask if there is any way to create a Chart in Smartsheet without using a numeric data? I wanted to create a chart using names/phases as reference but I received an Invalid Data error message. It says, "To create a char…
When choosing attachments in sheets it gives you the option for upload from computer, g-drive, and hyperlink.
When using forms, the only option appears to be upload from computer. Is that the case or can a user select hyperlink or G-drive…
Using Smartsheet29Jonathan Barfoot
In recent times, my copy/pastes sometimes don't work. Most frustrating.
One consistent workaround is to log off from SmartSheet and then log on again and then immediately do the failed copy/paste.
It seems to be triggered by attemptin…
Using Smartsheet44Rob Hagan
Is there a way to create hyperlinks to go to a form that is already created?
I am trying to create a central hub for all of my team requests to sit under, so we can send out one link and have all the different requests sitting th…
Using Smartsheet12Brandon Mallette
HI - Anyone know if it is possible to create a custom sort in smartsheet?
Example, in column “Title” I have the following values:
· Assistant Professor
· Associate Professor
If I sort by title a…
Using Smartsheet9Tanya Brooks
I was eager to checkout the recently released Smartsheet Charts, I have produced a couple of Pie Charts based on some real time data but seem to have found that limited funtionality/formatability (e.g. Not able to re-position labels) restr…
I am working on an approval process. It starts with the use of a form to take in the data, and then the process is kicked off. I have two separate workflows, one for the new row being added; and the next if the size of the class or start…
Using Smartsheet18Tristen Hannah
Can anyone come up with a workaround for this situation:
I have a submittal log for a construction project. I attach and log submittals in Smartsheet as they come in from the general contractor, and Smartsheet alerts the applicable design…
Is there an option to automatically export to a google sheet? I know you can set up a recurring email w/ attachment, but was curious if there was similar capabilities via the export function.
Using Smartsheet9Amy Gutirrez
I created a tracker that I then created 20 copies of and each one is used by a different team. The sheets all have the same workflows/conditional formatting. The business owner keeps wanting to make tweaks to the sheet (like to add a colum…
Using Smartsheet8Julia C Peterson
I have a database and a sheet linked to it which is fetching few of the database columns.
Whenever I sort data in the database the data in the other sheet (linked sheet) is not getting sorted.
Any suggest how i can keep the data in the lin…
Using Smartsheet18Prajna Jain
To make data entry easier, I am using multi-select.
When it comes to reporting this makes the process difficult because I want to create a pivot table to show where the items appear in each individual category. My example below will pr…
Not sure whether this is request for change or an error in our licensing/configuration, but the unlicensed users in our configuration see a message that reads "You have limited access to Smartsheet. Upgrade to use premium fe…
Using Smartsheet22Rob Hagan
I have developed a workflow with 5 Managers Approval request. I want to know if it possible for a manager to re-assign the approval request to another manager if they don't own the sheet?
Is there any way for uploaded files on a Google form to be attached to the Smartsheet as regular attachments rather than in a column on the sheet with links to the Google Drive?
i have a sheet with my compeny task that update every day by project managers.
each task get the data from the PMs ever the at 08:00 morning.
i want to see all in Card view when the section is WW (work week)
the problem is if i put all…
Using Smartsheet17Netanel yosef
Occasionally, I am seeing reminder icons disappear from sheets. Seems to go away with a refresh. Anyone else?
I am building a change control log. Is it possible to pre-populate a form with cell data from a sheet? For example, project name, ID, customer, description and resource from the sheet to help the process of logging a change to the change c…