In a sheet, we have a column formula taking a value from another sheet using 'reference another sheet' we would like it to create a hyperlink back to the other sheet where it took the value from. How this is helpful: we have a vendor portal where our vendors send in their invoices via a form to a sheet, then in one of the…
=DATE(YEAR([Last Month]@row) - 1, MONTH([Last Month]@row), 1) =DATE(YEAR([Current Month]@row), MONTH([Current Month]@row) - 1, 1) I have been using this above formula for the last 6+ months in 20+ sheets but I noticed it is not working anymore. Did something change or do I need to update something since the year changed?
What can I do so the data labels don't overlap, in the image above the 0% is overlapping with the 17% in Feb?
In a form can you add in a column formula as an option to show up on a form? I don't think so because I don't see it as one of the fields to choose from when building the form. I was wondering if anyone knows of a workaround? What I'm trying to accomplish is if the user selects a certain location, the financial fields will…
What am I missing...I'm trying to sum the 'Headcount' column only if the Name column = "OPEN" and the Title column = "Supervisor". I keep getting the #INCORRECT ARGUMENT SET error. TIA
The second/third step in my automation process is not working? It doesn't ask for when to alert so I would assume it is instant? The 'Admin Team Member' is not getting notified? Does it matter that in my test sample it is the same person as the approver?
Is it possible to set up automation to notify someone when a sheet is exported?
I'm looking for a form to be automatically sent when an email is entered into a separate sheet. The form is from a separate sheet which is a survey. Once a new employee starts and we have their new company email address the recruiter would enter it into the On-boarding file and once it is entered I want an automatic email…
Can I revert to an older version of a sheet from last night? In the history I don't see where someone sorted the rows, so I'm not sure what happened? I thought there was a way to revert to a certain time of day? I don't know anything about a back up so this information would be helpful too?
I'm getting the #NO MATCH error when cross referancing to a nother smartsheet file that has close to 20k rows, do you think this is causing the error. I looked up one of numbers and see it but still getting the #NO Match error. It is not finding any of my 500+ rows? Any thoughts here? First image is teh {Smartsheet BNI BU…
