-
How to combined VLOOKUP and SUMIFS
Hi everyone, I encounter one issue creating formula and linking between two different sheets. I don't know which formula to use but let me share with you what I have done and if you all have a solution to my problem, that would be great. I'm working on a financing sheet, it will be a lot about proposed cost, final cost,…
-
Issue w/ Rules - Being unsubscribed
Is anyone having issues with rules and being unsubscribed? With the smartsheet (server side) issues over the past few weeks, i've had a ton of sheets to re-do all the rules on because there is no global option for that. Anyhow... This week we are experiencing issues w/ the rules unsubscribing users out of nowhere. As you…
-
Commission tracking
Good morning Smart Sheet community. I have been tasked to create a commission tracking smart sheet for our sales team. If you have a pre-fab sheet(s), and willing to share, I would be forever grateful. Otherwise, here was my thoughts on said sheet. First sheet would be for the actual sales. This would have a form available…
-
Can cell data create a row?
Let's see if I can properly explain my question! I'm using the Meeting Agenda template to create and track agenda items. I'm then using that sheet to add notes to each agenda item during the meeting. I would like to use a modified version of the Agenda Item Follow Up template to turn any of those agenda items (from Meeting…
-
Using formula in a Date column, then using SUMIF to total
Hi all, Relatively new to Smartsheets and I am looking for a bit of guidance here. I am trying to put together a 'Resource Forecasting Tool' for our company, wherein the users can populate either an 'Personnel Discipline' or 'Equipment Item' to forecast, they then will enter the start and end date and the quantity…
-
Grid to Card View
Is it possible to create a project plan in Grid View and have it seamlessly transfer to the Kanban board on Card View? The hierarchy on the Grid View impacts the display of cards on card view. See attached screenshots. Ideally, I want to enter the project plan in Grid view and then have all the tasks show as cards in Card…
-
#Invalid Operation - Error
I have a issue that I just can't figure out. I have 2 identical Smartsheets one was saved as new from the other. I have the same formula in the same column in the 1 Smartsheet example I get a #INVALID OPERATION (Red Arrow) however in the 2nd Smartsheet example (Blue Arrow) the formula works In the attached I have provided…
-
Find Corresponding Value (in Pieces) in Other Sheet
I have two sheets: Sheet 1 that people use to submit requests for course redevelopments and Sheet 2 that has a record of all 1,000 courses (with a link to the "master" in our learning management system). We are in the process of standardizing the names of our "masters". Essentially, they contain three pieces of…
-
Creating a Master Sheet Composed of Dependent Dept Sheets // Sheet Linking // Sub-Sheets
Hi Community - Looking to crowdsource the best method of creating a Master Sheet (think: Company ALL) composed of smaller Department Sheets (think: Marketing, Development, etc). The ideal set up here is that while only I may have access to the the "Company All" the dept heads have access to their respective Department…