-
NEW! Your survival guide to formulas is here. Meet the Formula Handbook.
Hi Community, Whether youβre summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs. The new Formula Handbook is here to help formula beginners and pros alike. This template contains: A glossary of allβ¦
-
How do I update a status based on 3 different approvals.
I have 3 different approvers for work. I want to update a status field so that I can send out an automated email to alert the next person in workflow. Here is where I'm at. =IF( ("[Approver 1]@row = Approved" and "[Approver 2]@row = Approved" and "[Approver 3]@row = Approved"), "Approved") I keep getting the messageβ¦
-
Has or Contains formula help with IF statement
I feel this is simple but I cannot seem to get it to work with IF, HAS, CONTAINS functions. I want a formula that will read through a range of cells on one row at a time, and if a certain condition is met, give me a specific text back. See photo - any suggestions? fyi: the 87.8% is dynamic, so the number changes every dayβ¦
-
Blank rows added to bottom of sheet / form
There is a group of about 10 rows that are all blank that are automatically being added to a sheet we have created. We do have an active form for this sheet for project requests. there is no information in any row listed. I have tried deleting them by right clicking and "delete row" and also the Row Actions to delete andβ¦
-
Is there a way to have dynamic cell updates? My previous attempts were unsuccessful.
I have two (or more) sheets, one sheet called βMaster Sheetβ and another called βLibrary 01β. I want to create a drop down in Master Sheet with Options βA-Hβ which populates data from Library 01 and automatically changes based on the option chosen from Master Sheet. Is regular Smartsheet capable of this? I've tried usingβ¦
-
Created Date Column Background behaviour
Hi Smart Sheeters! I have a created date column in my sheet which updates whenever I open up the sheet. I have a column that uses it (See formula). And it also updates whenever I open it up. This doesn't feel like normal behaviour. Can I change my formula to take the time from a created date column as a string/text valueβ¦
-
Formula to import text in same column from one sheet to another
Hi, I am a newbie at formulas. It's not intuitive to me. I have two sheets that have similar columns. I was using cell linking but it wouldn't allow me to create any more links (choice was grayed out). Anyway, I want to copy info from one sheet into another. Both are the first column in the sheet with similar names. Sheetβ¦
-
Conditional Cross Reference Help
@Paul Newcome need your help! I need a formula that when any value in a column from another sheet is entered, it will then copy the text in another column in that same sheet to the sheet I am creating.
-
Can't use Vlookup or Index Matching
Hi all, I have a sheet which is organising workflows for different departments. Departments are separated into different sheets since they have different tasks and metrics to monitor and some activities are sequential therefore moving once finished with one department by automation. How can I get row info from 1 sheet toβ¦
-
Locating the parent of a parent
I am trying to take the value from the primary column of a level 0 parent and insert it into another column in a level 2 child. =PARENT([Task Name]@row) works fine when there is only level 0 and level 1. Something like parent of a parent is what I have imagined would work, but =parent(PARENT([Task Name]@row)) isβ¦
-
Cross sheet COUNTIFS
Smartsheet Braintrust - I need your help. I am creating a sheet with a few metrics, and one of them is Incidents Closed in the Last 7 Days. The metrics sheet and incidents sheet are separate, so there need to be cross-sheet references. The incidents sheet includes many columns, but the ones relevant to what I need areβ¦
