-
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?…
-
Automation problem
Hi, I'm having issues trying to get my automation to function. I have tried it numerous ways and it still doesn't work. Basically, if anything but New York is selected, I want a link email to go out with an additional form I need to fill out. Here is what my workflow looks like: I just cannot figure out what I'm missing…
-
Help to link health status formula to status
Hi, Need some help here is my current formula for health status in project plan. =IF([End Date]@row = "", "", IF([Summary Helper]@row = 1, IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIF(CHILDREN(), "Green") > 0, "Green", ""))), IF(Status@row = "Complete", "Blue",…
-
Welcome to the ENGAGE Guestbook: Share & Enter to Win!
Hey there, ENGAGE attendees! We hope you're having the best time at the conference. We'd love for you to take a moment to sign our virtual ENGAGE guestbook. 😉 This gives you a chance to win one of the cool gift baskets, filled with Smartsheet swag and products from local businesses. Want one? Participate by telling us:…
-
Projects releasing today + 60 days
Hi all, I have a formula such: =COUNTIF({project rel +2mos}, >=TODAY(+60)) that is returning a 0 count, even though there should be a count there. I do have the specified column I'm calling set to "Date". Any help greatly appreciated!