-
Row Copying Issue
Hi I have a sheet, and in it there's a VLOOKUP to another sheet. I set a Copy Row Automation so that when the vlookup cell is filled, it should Copy the Row. I setup the Wrokflow like this: Trigger: When a Row is Changed When: <Field> Changes to Any Value Run Workflow When Triggered So, everything pulled into the sheet…
-
How do I return Last Match with VLOOKUP
Hello, My VLOOKUP function is always returning the first match other than the last match. The lookup table is updated chronologically, and I need to return the most recent data which will always be the last match. I'm open to other solutions that use other functions. Thanks.
-
Is there a way to write a formula that will raise a flag to if row data for household size AND ...
I am trying to write a formula that will raise a flag if the row data fits specific criteria for determining income eligibility for a project. Basically it would be if the data on that row in the household size equals a number and if the annual gross income is less than or equal to a dollar amount, we need it to raise the…
-
Snapshots and Logic Driven Archiving
Hey all! We are just about done and ready to parallel pilot our Request Management through Operationalization to Close solution and was wondering if there's an easy way (or hard way) to do the following: Use Case 1: Right now my teams' weekly status updates (which is a cross-sheet report between Intake and Metadata) keeps…
-
Approach to count new rows by day for reporting
We are using smartsheet to track issues from UAT and I want to be able to report on the number of issues added each day, and closed each so I can create a bar chart for the dashboard. I was able to calculate the number of new each day with this formula using the system created date column. I have a field for status and I…
-
Automatically change Status RYGB
Any formula to automatically change status from RYG to B once my project reached End Date?
-
Formula to populate multiple contacts into a cell based on role
I used the following Match/Index formula to populate the "Assigned To" column of my sheet based on the "Role" column. I have a look up table at the top of my sheet. =IFERROR(INDEX([Assigned To]$6:[Assigned To]$20, MATCH(Role@row, Role$6:Role$20, 0)), "Needs Role") There are many tasks on my sheet which are assigned…
-
SUMIF - all options EXCEPT one (NOT function?)
Hello, I am having some issues trying to create a formula to sum all the values in the column (called Scheduled Anode(s)), except for rows where a status column reads "No action required". This was my best attempt, but it doesn't give the result I want, it sums to 0 instead of the 40 or so value it should be.…
-
Ignore negative: Calculate time between dates ignore negative numbers
I am running a formula to calculate the days between a start date and today(), if the number is less than 25 then it inserts today's date in a cell. That cell is then used to trigger an email to a user for action. If the start date is in the past the calculated days between is a negative. I want the formula to ignore the…
-
Multiple IF Statements -- Status Updates
Hello, I am trying to put together a sheet that reflects as a holistic "Status Update" depending on whether or not something has been "Approved", is "Pending", or has been "Denied". I attached a photo that shows what I am trying to get my sheet to reflect and what is happening with returned values. Here are the examples of…