-
Using "Update Immediately" in Data Mesh
Hi all, I am looking for more clarity on the issues with the "Update Immediately" option in Data Mesh. I am familiar with the fact that the "Update Immediately" option is not always reliable or timely and want to understand more about why that is so I can work around this issue. Data Mesh is transferring business critical…
-
Data Uploader Filtering
Hi All, Just a quick question regards the filtering in Data Uploader. I'd like to look at everything incoming from the report I pull for the last 30 days. Having already mapped the columns, I'm just wondering what would the correct formula criteria be. Incoming equals TODAY()-30 - or something similar? Screenshot attached.…
-
"Publish User" when using Microsoft Teams
How do we set up our Smart sheet in MS Teams so when comments are made and a user is logged on, the comments will track date/time stamp and the user name? Currently, if a comment is added thru teams it only shows published user.
-
Issue with permissioning SS for MS teams notifications
Hi, I've been trying for 2 months to address an issue with setting up automated notifications from SS to MS teams wherein I get the following error. My IT support team have tried granting me admin rights in the permissions menu of the Azure AD but it's really not clear how to resolve this issue. We have also tried getting…
-
Vlookup cross-sheet reference
Hi, My vlookup gets a "#NOMATCH' for one value, but works for all the other values. It works for everything except 'Manufacturing' - see screenshot. =VLOOKUP(Department@row, {Executive Email For Approval}, 4) Any ideas? Thanks, Nichola
-
Intake sheet - new rows to contain formula
Hi, In my intake sheet a form creates new rows. How do I have a new line automatically contain a formula? (In this case it's a cross-sheet vlookup.) Thanks, Nichola
-
Control center
Hi, Someone know the pricing for Control Center add-on? Thanks
-
Dynamic View & Images
I'm using Dynamic View to share out a product catalog to our Sales team. We've been using this setup for almost a month now and I've been asked to add product images on a row (not as an attachment). It works fine in the sheet: But it converts to text in the DV: Attachments aren't a great option for this because to view it…
-
data uploader
im using this for the 1st time to fetch data from a one drive excel sheet, if i choose replace as a option on uploader the data is not refreshed when the source data changes, however if i pick replace, then all the data is refreshed, but the formulas i create a now deleted as its a replace (even linked cells to another…
-
Getting error "No approved project found in config approval settings, please contact PMOs."
Getting error "No approved project found in config approval settings, please contact PMOs." when attempting to create a new project with Control Center. I have checked the Project intake sheet, the projects are approved and the project status is "unstarted" for one and blank for another (note the Project Status column is…
