-
formula issue
i need some serious help with formulas. I have formulas that are supposed to pull info from a sheet and when i want to change the column or copy the formula it's changing other forumulas in other rows. this was from a template. i have had to make changes and am not sure how to fix this but i need it to work :( it's so…
-
‘UNPARSEABLE’ Messages for Column Formula
Am new to Smartsheet Have two columns; Duration Value and Work Effort Trying to apply a formula to a third column, and then convert to a column formula, but keep getting ‘UNPARSEABLE’ Messages The equation is follows: Work Effort / (Duration Value * 8) Have tried every variation and function, but to no avail _Peter
-
reoccurring weekly task with auto updated due date
Hi, I'd like to set up a reoccurring weekly task. When completed, it would reset the row status from "done" to "ready to work". The due date would auto-advance by one week when the status is reset to "ready to work" NICE TO HAVE: I know from the get- go that some months this task won't occur at all. Can I schedule the task…
-
How to keep current and archive records at same time
Hello All, i have a sheet where it has a product column has product names. Few product names are updated and others are the same. for ex. TCS becomes Tech Cost Service i want to keep both records so i know which is updated or not. is there any way, i can keep both the current product name and the updated name with new…
-
Dashboard reporting grouped information
I am trying to show forecasted amounts by business unit. I was able to figure out how to create the report and group the sums by BU. However I only want to show the business units and the respective totals, on the dashboard. I can't for the life of me figure out how to pull only that info into the dashboard.
-
Help with ranking based on criteria (RANKEQ, COLLECT)
Hello, I am trying to rank location names by the number of activities they've accomplished within their specific region. Dummy data: When I searched the forum, I found a few examples of RANKEQ with COLLECT. However, I receive errors when I insert this: =RANKEQ([Total Activities]@row, COLLECT([Total Activities]:[Total…
-
Can Smartsheet logic (in forms) eliminate a response from the next question?
I'm thinking no because I do not see anything in logic that would support it, but here is an example of what I'm trying to do. Ex: Who is your first place choice? A, B or C Who is your second place choice? A, B or C, etc. If first place choice is A, then I want only B and C to populate for second place choice. So on...and…
-
Sumifs - Cross sheet reference
HI, I am very new to smartsheet, but trying to build a rollup sheet from a source sheet. I need to pull the $ amount for every "Executed" contract. I've tried the below formula and SUMIFS({Sheet - Contract Management - Complete Lib Range 2},Contract Amount/NTE:Contract Amount/NTE,Status:Status, "Executed") SUMIFS({Sheet -…
-
Issue with If and Index
Hello, I have two sheets, and I am attempting to use Index/Match to reference a cell on another sheet. My issue is due to the multiple if statements in the cell already. The following formula is in the cell: =IF(Confirmation4 = 1, "STOPPED", IF(Confirmation21 = 1, "EXPIRED - PROVISIONAL", IF(Confirmation37 = 1, "REJECTED –…
-
Parent Row to display Child Row value based on upcoming due date
I need to create a formula where the parent row determines what it displays in its cell based on the following criteria: Display cell data from the child row that has the earliest date So 2 columns... VNT and VNT Due 123 1/1/11 456 2/2/22 I want the VNT parent row to display the VNT child value that has the earliest date…
