We are limiting the number of licenses that we can make available for requestors because we have more requests then we have available. What I've been doing is seeing which licensed user hasn't logged …
Hi, I have one column written in a currency format. Lets call this column A. Another column written in a regular number format B. When I try to create a column formula in Column C like: Column A/ Colu…
Hi Team, I have a sheet dealing with people being onboarded. I am trying to count the number of people that "Completed" their onboardings per week. Meaning week 2 in the given year, three people were …
This question has been asked in a number of ways before. I have two sheets. All I am trying to do is get the total amount of pieces of equipment based on different criteria. Here is the first sheet: T…
I have a sheet that is supposed to move rows to another sheet if a column is checked. Well its not working. It only works if I manually change a cell within that row. In the second screenshot above, i…
The screenshot above is done in EXCEL, and its calculating the allocation% percentage of each project by month for an individual. It also has a blue bar that highlights the months that have values in …
I have a sheet where the a person is in one column and the projects that he's assigned to are in the next column called "Projects". I am trying to create a report to measure the allocation% percentage…
I have a project where an individual tester (end user) will need to complete their own checklist for testing a process. Each individual is assigned a role, so whatever role they are assigned is the te…
Maybe a little long, but some backstory is necessary to get a better understanding on what's going on and if I'm approaching this issue right. Currently my Smartsheet is setup where there is a formula…
I have a smartsheet that calculates the cost of equipment when its being booked by a garage. Everything is working well, except my formula is calculating the cost when the equipment is booked by the s…