-
Nesting If Statements and Dates
Hi, I am trying to create a status column that will populate a field with the parameters below: "Yes" if all of the cells in the row have "Yes" selected. "Late" if the today's date is greater than the due date and all of the cells in the row don't have "Yes" selected. Or else "No". I have tried several different formulas.…
-
Is it possible to embed custom HTML or JavaScript in the smartsheet dashboard?
Hello, I am trying to embed an interactive dropdown menu created using HTML in the smartsheet dashboard using the Web Content widget. It was embedded but it showed up as an error. I want to know if anyone tried to embed HTML or even JavaScript into the dashboard. If it is possible please let me know. Thank you!
-
Dashboard. Rich Text Widget. How to remove hyperlinks?
I have a text (paragraph) which is linked to another sheet. Is there a way to remove the link without deleting the entire text?
-
Dashboard/Report not updating
We have a team dashboard that is not showing correct data. It seems that the underlying report is not updating. What is wrong?
-
countif and contains statement for extended drop down menu
Hi all, I would like to reach out to the community to help me solve my (probably simple) issue I am facing. To provide you with some context: I am building an online database to enable tracking all the requested amendments and to gain inside into invoicing on a small scale. This database is created for different layers to…
-
Embed Dashboard Widgets into Documents
It would be great to be able to embed dashboard widgets into documents in the document builder, allowing for the creation of fully formatted project reports to key stakeholders.
-
Embed a Miro Board Onto a Smartsheet Dashboard?
Hi All, In the past I have worked with lucidchart to successfully embed a flowchart or other lucid app object to embed content from lucidchart into my Smartsheet dashboard, but when following similar steps to do the same with Miro I get an error code pictured below. Has anyone ever successfully merged the 2? I am mainly…
-
Chart not showing all data when sheet is sorted
Hello, I am encountering an issuing when trying to sort the information in my sheet that is being displayed in a chart. When I sort on the columns that contains a metric that I am displaying it reduces the amount of data being shown. The first set of images is displaying all of the information I want and the sheet is…
-
can a work insight be added to a dashboard?
I really like these charts and would like to add them to a dashboard, but I do not see how.
-
Extracting multiple lists by category
Hi. I have a master sheet where each row is allocated one of four categories. I would like to extract this data into another sheet, into different columns dependent on the category (i.e. four columns for name, one per category, four columns for date, one per category). All the functions I have tried (vlookup, match/index…
