-
Building a Sum If Statement
I'm trying to build a SumIfs statement that calculates the number of hours by type (Sick, Vacation, Personal) by employee ID. I'm able to do a simple SimIf for the total, but struggling with how to break it down by sick type. This is the statement I'm using and its resulting in an incorrect argument: =SUMIFS({Employe…
-
Dynamics metrics across new sheets
Goal: create metrics for a dashboard that automatically update when new project plans are created in the same workspace. For example: KPI=Number of late deliveries across all projects at a client I can create a metrics sheet and create a formula to pull data across sheets, but each time a new project is started, I would…
-
Having multiple paragraphs in one cell for Approval Request
I'm trying to use Approval Requests for something and some of the columns are analysis's and are written in paragraph form. This is a formal process and I want it to look as professional as possible. Even though in smartsheet I can use Ctrl+Enter to add a space and create a new paragraph within as cell, when it is sent in…
-
RACI - 2 in 1 Event sheet - template usage
I'm having trouble understanding the template - and can't find directions for how to use or specifics on the formulas used - which are huge...so the T- # is what is confusing me. Any directions or assistance would be great.
-
Nested IF statement with date comparison
I am either getting a #UNPARSEABLE error or #INCORRECT ARGUMENT with my formula. I am trying to compare two different date columns (Posted Date) or (Last Reviewed) against another date column (Deadline) to indicate a Yes or Review Needed. One of my columns (Last Reviewed) could be blank because it has been reviewed since…
-
I need assistance with a parent/child formula
I would like to return a specific value in a parent row when all the values of the children is equal to a specific value. I would like the parent row to automatically show complete as soon as all the children rows are completed. The cell can be blank if all the values are not complete. I used the following formula to get…
-
Row report with spreadsheet summary columns - Relatório de linha com colunas do resumo da planilha
In the row report create the possibility to include columns with information that are in the summary of the spreadsheet. For example in the summary of the spreadsheet we have the fields start date and responsible. Allow the creation of a report of project lines with the tasks of each project, project start date and…
-
Limit to Shares for Admin and Editors w/o Subscription
Hi Smartsheet Community, I do not have a paid subscription but was set up as an Admin for a sheet. I had only shared it with 2 people before it sent me a message that I had exceeded the number of email recipients that I could share with. Is this accurate? Do "editors" with sharing privileges have more shares that admin?…
-
Functionality Question
Hello, I am more of an Excel guy who is attempting to wrap my head around Smartsheet. I have a scenario and I am thinking it can be done, it seems like I almost find the answer but just not quite. I have records which require attention, usually in contacting users and getting require, late training complete. There are a…
-
Sheet Summary Report Grand total row ?
I am bringing in 2 separate sheets into a sheet summary report using a custom column called "Total Revenue" which is a sum of each individual sheet's revenue rows The sheet summary report is showing correctly both rows for each sheet and the corresponding totals for each sheet. e.g. Miami $138,875 Tampa $264 My question is…