-
Formula to return a checkbox on Sheet B, if a % column in Sheet A = 100 + move rows
Hello there, I have 2 sheets: Sheet A - Base File, where i have % Column where i input the current numbers. Sheet B - Transfer to File, where i need to add a checkbox to a row, if the % Column in Sheet A is 100 %. I have managed to make the reference where: =IF({Base File Range 5} = 1, 1, 0). BASE FILE TRANSFER TO FILE My…
-
Trouble with long date formula
Hi, I am working on something that will tell staff when the open window for a visit is, based on the visit category. Rule 1: Visits in the category of 1, 2, 3-5, 6-10, and 11+ years should be annually and the window is their DOB +/- 1 month. This portion of the formula works. Rule 2: 3rd trimester visit should start 197…
-
Dynamic year formula for the previous year
Hello! I would like to show the average score for the previous year without indicating specific year (instead of showing 2023 I use formula (YEAR(TODAY()) – 1. =AVG(COLLECT({Vendor Evaluation Sheet - Archive - Score}, {Vendor Evaluation Sheet - Task ID}, [Task ID]@row, {Vendor Evaluation Sheet - Archive - Created},…
-
VLOOKUP formula pulling data from another sheet
I'm using the VLOOKUP Formula to match the "Application" in table 1 to "Application Name" in table 2, then return the "Primary Product Family" from Table 2, Column 2 to "Program" in Table 1 where the formula is. =VLOOKUP(Application@row, {Applications}, 2, false) What I'm I doing wrong?
-
How can I bring cell values from one sheet into another sheet "multiple values cell"?
Below is the source sheet destination sheet
-
anyway to create formula for matching current user to cell contact list value
I've tried multiple things, even making them select a dropdown on the top row so the "modified by" for that row captures their name then using another column with contact list property with the formula "=[modified by]@row" for the remaining rows. But even this fails since in the "standard" contact list dropdown my name…
-
Can I Import a Large Excel Sheet with Embedded Formulas into Smartsheet?
I am needing to import an excel sheet into Smartsheet with 10+ tabs at least 16383 columns. There are imbedded formulas referencing different sheets in the excel. Is there a way to go about this rather than importing one of the tabs at a time, and manually rewriting a lot of the formulas?
-
Is there a way to create a flow chart that leads to a result depending on how the user answers?
Hi! I currently work in a manufacturing plant where in order to quote a new project we need to create a chart showing the number of people and the line speed required to run the project. I am currently the only one on my team that has the knowledge to make these, but would love to create a flow chart type system where…
-
Join formula started adding a leading zero on text from certain columns
I created this formula, and it worked great the first two times it was used. The third time, it added a leading 0, which is NOT present in the [Circulation Requirement Details 3] column. I did further testing triggering the function using [Circulation Requirement Details 4] and [Circulation Requirement Details 5], and 0 is…
-
Record the time when specified criteria are met
Hello, I'm new to Smartsheet and I want to set up a workflow that records the date and time automatically when a previous column's value is changed to "Yes". I know there's a template for recording a date when specified criteria are met, but I couldn't edit it/find one to automatically record time. I see that there was a…