-
Dashboard data not refreshing?
I have created a Dashboard where I’m using the chart widget, the data is being pulled from a sheet (sheet 2), were I pull data from a different sheet using formulas (sheet 1) to be used on the Dashboard. Sheet 2 is only used for calculations and counting for specific models of our department as Sheet 1 is a global sheet…
-
Bi-directional celllinking
Currently, when cell links are created, the updates have to originate from the source cell, and then propagate through the subsequent links. Particularly in a Control Center setup, you can have 3 or more sheets that link (from the intake sheet, to a metadata sheet and then to the project plan, is one example). As an…
-
Alteryx to Smartsheet
Is anyone currently dumping data from alteryx into smartsheets? I would really like to be able to do it. Currently I am outputing to G.S. and then pulling the data into smartsheets via Data Shuttle. It works, but I'd love to cut out the middle man.
-
Merged: Increase the cell count limits
This discussion has been merged.
-
I am needing help linking cells to another sheet based on specific criteria.
I am trying to link cells to another sheet (Name column) based on the specific local chosen that they are in (Local #26). I have tried using this formula below, but it only populates one name not the entire set of guys in that union. =INDEX({Safety Awards 2024 Range 1}, MATCH("Local #26", {Safety Awards 2024 Range 2}, 0))
-
Unable to Access Large Sheets But Data Still Accessible
I've been having an issue the last couple of weeks with two very large sheets. One is automatically updated via Data Shuttle and the other has rows pushed to it weekly. I can't open them directly but I know they are still functional because I can still move rows to them, other sheets can access the data via formulas, and I…
-
Increase in cell limits?
I attended this year's Smartsheet Engage and there was a big announcement that Smartsheet would be increasing cell maximums in sheets at the end of the year. Any more word on that? What is the new max cell limit?
-
@ Question
Is it possible to send a message to every one shared to a sheet?
-
Formula to lookup a value based on start and end date
Hi All, I need your support on this case. I have a project to improve the current sales report layout and I need to extract the Vendor Support data for each item depend on the sales records, and the start and end date for this vendor support. Here is an example: Below is the table where I want to have the formula to…
-
TODAY() returns yesterday or tomorrow depending on your timezone
Hi Community, We have an interesting issue here in Melbourne, Australia when we use the TODAY() function. At various times of the day, it can return yesterday's date rather than today's date (as it should). Took quite a while for this to be acknowledged, but the behaviour has been confirmed now by a couple of senior…