-
Add Values to Each Dropdown Value
Hello, We have a Supplier Dropdown with the name of each of our suppliers. I would like to create a formula that takes each of those values and goes out to another table (Supplier Directory) and returns the City, State, and Country of each of those suppliers. I have the following formulas that look up the city, state,…
-
Updating company and email address
This discussion was created from comments split from: New e-mail (domain) change with Business plan.
-
How am I able to change timeline colors, when no color setting appears when I right click?
When I right click the only option I get is to edit and not to change the color settings, and I am looking to change the color!
-
The sheet you are attempting to access is no longer published.
I published a report. For over two months now. I shared the published link to people. They hav been able to view the report since then. But now they are getting the message "The sheet you are attempting to access is no longer published. Please contact the sheet owner." I have checked the sheet and everything is in order.
-
Based on frequency selected change the formula for the created date.
I feel like this should be super simple but I am just not getting it right. Based on Frequency: Daily, weekly, monthly I want to change the next due date This will be calulated from Created column and +1, 7, 30 etc added. It works single instance =IF(Frequency@row = "Daily", Created@row + 1) but as soon as I try to write…
-
An error has occurred in Smartsheet Please log out and log back into the app before continuing. If
Hi guys, my team is receiving the following error An error has occurred in Smartsheet Please log out and log back into the app before continuing. If the problem continues, please request assistance at www.smartsheet.com/gethelp. Recently Open Solution Center. Help We already did the proper troubleshooting like clearing…
-
Need help with Index formula across sheets
I have a Master sheet that I would like to source information to subsheets for Project columns, of which then the % complete and date complete on each subsheet gets Indexed back to the Master sheet. However, I am needing to add 2 lines on the Master sheet to populate on all of the subsheets, but when I assign them unique…
-
Access to a longer published sheet
Hi! I created a Calander events availability tracker and I attached it to a dashboard that I am creating in Smartsheet. It is now unable to display and a notification appears saying that, "The sheet you are attempting to access is no longer published. Please contact the Smartsheet document owner." I am wondering how to…
-
Cell Links Between Sheets Don't Work Consistently
Hi - I have set data mesh cell links between multiple SmartSheets that I own. The properties of the columns on the different sheets match. In the Data Mesh set up, I've selected: To overwrite content To create cell links To run immediately I have multiple instances where data changes on the source sheet and does not update…
-
CONTAINS FORMULA WITHIN A DATE RANGE
Hello, I'm trying to create a formula to count / sum the number of times a cell contains some txt within a date / year range. The formula works for regular cells which contain only one piece of txt. However I'm trying to count from a cell which has multiple entries. I'm sure this is an easy one. Can anyone help please?…