-
Help with If formula using Icons
I need your help to show status as Yes, No, Hold using this criteria: No - 90% + Hold - 51% - 89% Yes 0% - 50% This is my current formula, where the 'Yes' and 'No' icons show up as intended, but those that fall between 51% - 89% are showing the red X icon for No, not Hold. =IF([Resource Utilization]@row > 0.9, "No",…
-
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…
