-
Formula to calculate count of checkboxes in multiple columns and child rows
Hi Everyone, I'm trying to write a formula that adds up the number of unchecked child rows in the Complete column and then subtracts the number of checked rows from the Non Applicable column. The result should be a number of tasks left to be completed from within that parent and child section. I've tried a bunch of…
-
Need to build formula that includes a drop down menu as an option, need advice
I am trying to build a formula that includes a drop down menu as an option. This is what I am trying to do ... =IF([COLUMN1] = "Campus name", then [BUILDING NAME], otherwise "Please select your campus before selecting the building name") * COLUMN1 would be a drop down menu with campus names * BUILDING NAME would be a drop…
-
General Plea for Openness
I would like to ask community members to add some details into thier profiles so that we all can get a better understanding of who you are, what industry you work in etc. The comunity is about sharing, helping and working together and this is much nicer when you know a little about who is asking for the help or guidence.…
-
Still Looking for an IF function that does nothing to the cell if False
I asked about this back in April and got a few suggestions but nothing that really worked for me so I'll try again. I keep track of the hours charged to around 35 projects by people in a dozen functional areas on a weekly basis and send the monthly total into our finance team for their revenue recognition process. I use…
-
Trying to create a fancy email with status reports from multiple teams
I'm trying to go a bit above and beyond, using SmartSheets to track the status of multiple projects across multiple teams. Currently, we have links to multiple sheets (one for each team) and they manually go in, add a new column per week, and fill it in with a bunch of text explaining the status of that project this week.…
-
Header column
Hi All, I am having the hardest time trying to figure out how to keep the top column of my sheet as a header column. Is there anyway to accomplish this in Smart sheets. I have created the form and a web form for users to add data but I want the data entries to post on the sheet under the header. I'm hoping someone can let…
-
The Power of the SUMIFS Function
When I discovered the SUMIFS statement recently it solved a problem that had made me keep things like the project timesheets for our company in a very rigid format that basically listed all projects and functions (types of work) that could be charged to. I had wanted to let people select the project they were working on…
-
Calendar View
Is there a way to hide the weekends from my calendar and Gantt chart.
-
Initial Setup Assistance: Hierarchy Req- Multiple Clients, Multi Projects, Multi Tasks
Before I get to it and go crazy generating all my works, can you please offer assistance in the best way to set up SS for my needs. Essentially, I want to be looking at one project at a time...my trials have left me with multiple tabs across various projects and clients, it gets confusing. If you are familiar with OneNote,…
-
Individual Sheet Sharing has turned into Entire Workspace Sharing???
We use link sharing to share individual sheets with customers and employees. Now the link provides a link to the entire workspace. Is there a reason for this change? Is there a way to still link to an individual sheet?
