-
CountIfs- How many of one name in a date range
I have - a column containing start dates, that spans 2019 a column containing an assortment of names that re-occur on a random basis. I want to count how many times each name occurs each month. Any help appreciated!
-
Linking upcoming dates from sub sheet to the master sheet
My company has a master sheet connected to all the different project sheets. Is it possible to have the next due dates listed in the project sheets automated to update on the master sheet? Currently, we're just doing this manually and it is a pain for us to constantly look at the sheets.
-
API VB EXAMPLES??
Why are there no VB examples shown in your "Smartsheet API 2.0" documentation when you have a VB example by the name of "vb-read-write-sheet"?? It would be VERY helpful if you included VB example code along with all the other languages you provide. Please tell me if you intend to add this?? Thanks David
-
Interactive Room Map
Hi all i have a room full of storage freezers. Within each freezer there are 4 shelves of four stainless steel containers. Each container contains 32 positions and each position is a project. is it possible to start with an interactive “map” of the room, where I can click on any freezer, select a shelf then a container and…
-
integration de smartsheet con gmail add-on
perdon, pero solo hablo español. No domino el ingles. Voy a transcribir lo que me dice el traductor. no veo la forma de vincular los correos con renglones de una hoja del smartsheet. Sorry, but I only speak Spanish. I do not speak English. I will transcribe what the translator tells me. I do not see how to link the emails…
-
Row numbers to a dashboard
We monitor the number of requests that come into 3 different Smartsheet forms week over week... i created a dashboard to show the requests within the past 7 days, but i need the rows to tally... even if the row number shows up on the dashboard itself, that works - i can simply see that 45 rows were created in the last…
-
Setting Alerts At A Row Level Using A System Column
We are trying to set up the sheet so that when a particular task is checked off as "Received or Done" it sends an Alert to the correct team member. We have a systems column to allow us to set it up to be row specific to the task, but it isn't working. Please see the screenshot below. Thank you in advance for any help…
-
The "New Smartsheet Navigation Experience" is Great! TY!
The New Smartsheet Navigation Experience is GREAT! The #1 feature I'm excited about is Browser Tabs and Direct Links. Being able to copy the URL straight from the browser. I spent a LOT of time as a champion and mentor explaining how to get the URL to share a specific sheet. I really believe this will enhance the new user…
-
Issues changing rows/columns
I have owner permissions on a smartsheet that I need to make adjustments to. I need to delete/rename columns, etc. The options aren't coming up for me to use. Is there something different I should be doing? I didn't create the sheet but I am set up as an owner, so it should work, right?
-
Linking information
Hi Is there a way to link folder names and drop down list items to a cell? I could then f.ex. have a sheet with overall Project Info where i list a number of sub projects, then create a folder named through a link to the sub project name in the project info sheet. In the same way maybe i want to assign some sort of…
