-
How to get VLOOUP to skip an instance if specific condition not met?
I am getting out of my depth and would like some help with a complicated equation. Background Info: Trying to streamline an item check in/out system that uses barcode SKUs and an item condition as a freeform explanation from the user. An item can be checked out/in by users and when they are checked in it will prompt the…
-
List one sheet to another when column contains text
Hi Smartsheet Guru's I have a sheet with many columns and formulas - which is increasing in size and slowing down. I would like to offboard some of the formulas to another sheet. Therefore, I would like to create a formula that looks in column Gap ID and if it has text (not empty) then the formula would copy the text in…
-
Days Lapsed/Column Formula
How do I create a Column Formula that will calculate how many days have lapsed since the "Issue Start Date"? I currently have the formula: =SUM(TODAY() - [Issue Start Date]1) but when I try to convert it to a Column Formula, it states it's not quite right to convert. Any suggestions?
-
How do i track progress based on output?
I have a project that involves building fences in a number of locations. Each location has a budgeted lineal distance of fencing, and we will need to track progress of distance completed against budgeted. I can do it in an excel spreadsheet, but would like to have it as part of my smartsheet plan. Am new to smartsheet!…
-
Using COUNTIF only if it qualifies...
I am trying to create a status report for items started. I think I have the formula for how many assigned, but now I need to identify of those assigned to 1 person, how many are started by that person. I tried =COUNTIF({Course Started}, {Team Movement Range 1"Donald Duck"}1). In the pic below Donald has 2 courses assigned…
-
Is there a way for a form in one sheet to populates a column in a different sheet?
I am looking to create a sheet that tracks who has viewed the monthly update videos on our company site. Ideally I would create a form that modifies the row, but I've read this is not possible. My idea for a work around is to create a sheet every month that has a form that asks for their employee number after they watch…
-
#Invalid Operation Error subtracting days from another Date field
I have a sheet that has a date field that is link in from another sheet (actually 2 other sheets) that is not working as expected and I cannot seem to root cause the issue. I have a column 75%/SD Date that I want to get 14 days before it in another column. Below are some things I have put in for the formula and the result…
-
Can I include a date from another sheet into a formula for my current sheet?
Hello. I'm pretty new to Smartsheet and can't find an answer to today's dilemma. For example, I have a two sheets: ABC Project (belongs to me) and XYZ Project (belongs to our vendor) I want to be able to calculate a start date on one of my tasks in ABC Project by pulling a finish date from XYZ Project? Basically like this:…
-
Date updating to Next Day using Index, Match, Max, Collect Formula
Hi, I'm working with two Smartsheets. (1) One sheet collects the data from a Smartsheet form. I added two columns to this sheet using the Auto-Number/System Feature (under Edit Column Properties). This features stamps new row entries with a date/time (Created) and by whom (Created By). I'm curious about the cell surrounded…
-
Problem with vlookup calculations
I am having a new problem with an existing Smartsheet that has worked fine until now. Existing workflows have stopped working. The problem does not appear to be workflow, but something else going on. We have a workflow that triggers off of a calculated field that is based on data in another Smartsheet. Users enter data…
