-
Reference Sheet Summary fields in formula in sheet
I need to create a formula that concatenates (JOIN or "+") several fields in my sheet summary, back into a column in my sheet. What is the syntax I need to use to be able to reference sheet summary fields? Thanks!
-
successor and predecessor between two project plan sheets
In my project there are 5 sheets in which some of their activities are linked to each others success. Is there any formula which I can use to define successor and predecessor between multiple sheets. Please advise
-
Creating a report with data from 3 different sheets
Hello! I'm new to Smartsheet and I need some help building the following two reports: I have 3 sheets, with the following main collumns: Sheet 1: Open Matters, containing #Matter, Client, Matter Type Sheet 2: Invoices, containing #Matter and Amount Received (Revenue) Sheet 3: Expenses, containing #Matter, Contractor,…
-
Running Total
Hi, I am quite new to Smartsheets and trying to set up a running total on a sheet that adds up the ongoing numbers input into another column. I have looked at some of the other posts on this topic but cannot seem to get mine to work. I have input the totals manually to show what I am after. Help!
-
Help with Formula to Count Projects
Hi all, I'm trying to create a formula in Smartsheet that counts the number of projects a team member is assigned to. In the report I have, the names are listed as first initial + last name (e.g., JDoe), but I want to summarize them using last name, first name (e.g., Doe, John). I was considering using a CONTAINS function…
-
Verifying Completion of a Form
Hello - I have a team of 50 and we are implementing read and signs via a form to ensure information is disseminated and read across the team. When someone completes the form I have created, it will record their email address and the date/time they submitted. How can I verify everyone on the team has completed the form?…
-
Formula to reference sheet auto ticket # with survey form link so that ticket id# follows process
Hi! I was viewing How to Build a Ticket Intake Process That Actually Works - YouTube and at 9:45 minutes in, the presenter references a formula that will point to the ticket number on the intake sheet, connect it with the link to a survey, so that when the customer completes the survey and their info is input into the…
-
Forumla Help: IF Statement with Vlookup Across Sheets
I have created two resourcing documents (pictures below for a visual) Resourcing Sheet - This is the sheet where we resource each project by person Resourcing Rollup- The sheet is rollup to show how many hours the are allocated each week by person and gives a rollup of hours What I am trying to do: Look up (example name)…
-
Sumifs with date column returning #Invalid Data Type
I'm attempting to use the sumifs formula and it is returning the error "#Invalid Data Type" =sumifs(Number:Number,[Date Column]:[Date Column],[Date Column]@row, Name:Name, Name@row) [Date Column] is a date column type; Number is a text/number with a formula that returns an integer; Name is a text/number with text inside…
-
How do I count non-blanks in a column?
Hi - I have a column in a referenced sheet that I need to count cells that have data in them. I'm struggling with the countif formula, not sure what to put for not counting the blanks and only counting the cells with data. Right now I have =countif({Lisa - test smartsheet Range 1}), …..and then I get stumped. The data is…
