Hello there, Thanks in advance for the help. I have a lot of data sheets that I want to summarize in one metric sheet. The data will be grouped based on the "assigned to" column. Right now, if I add a…
I am trying to write a formula to return the following: If Column A is not this, and Column B is this, return the result in Column B in Column C. Does anyone have advice? I think it should be fairly s…
Hi All, I have some sheets that have some heavy formulas and there are two issues: Whenever I update a cell (without formula) the entire sheet just start "flashing" with #BLOCK errors in pretty much a…
Hello Everyone, I have a metrics sheet that is counting specific text ("Alpha") from a source sheet with the following formula: =COUNTIFS({Supplier}, Description@row, {Status}, "On Order") **This work…
I just learned from a ProDesk session that we needed to use HAS rather than CONTAINS, since will have more than one entry in a cell. However, we have one set of counts for three criteria in a cell. Wh…
I want the smartsheet to automatically update the “WIP (local)” column each month and reduce the current months forecast to £0. As you can see below, the “WIP (local)” column has increased and the for…
Hi all, While I am getting the hang of Smartsheet, I'm still a novice with formula. I currently have a column formula =[Record Entry Date]@row + 8 This adds 8 days to the "Record Entry Date" to create…
I've search the community and I think I'm just getting myself more confused since I'm not good with writing formula's. I downloaded the "project plan" template and I am still confused. I would like to…
I want to divide the number of requests that were completed on time by the total amount of requests submitted that month. I'm referencing another sheet in my formula. The following is giving me "UNPAR…
I have the following formula checking for matching emails in two sheets & returning the date: =IF(Done@row = 1, INDEX({Submission Date}, MATCH([Email Address]@row, {Submission Email})), "") It's insid…
