I have a column entitled 'RAID' with dropdown options: Risk, Action, Issue, Decision, and a column entitled 'Auto' which is a column type Auto Number starting at number 1 (no prefix or suffix). This S…
I have a Smartsheet entitled 'MASTER List' with the following information (see Image 1 below). The columns 2021, 2022 and 2023 use cross-reference formulas to count the number of times these courses a…
I am trying to combine text in two different cells in two different sheets into one cell in another sheet. 1) Sheet 1 = Martyn's OKRIs, has two columns 'ID' and 'Martyn's Comments' 2) Sheet 2 = Jane's…
Please kindly advise on how I can calculate the % burn rate versus dates. For example, Task A1 has a duration of 2 days and the project 'Project A' is on day 2. It has been assigned to 'Joe Bloggs' wh…
I'd like to allocate non-working days for individuals tasked with deliverables on my project plan. I have two Smartsheets: * Sheet 1 = A project plan - showing all allocated resources against multiple…
Hi team, Could you kindly help me out with the formula syntax for the following scenario please: If the "Rag Status" column is 'Red', and the "Complete" checkbox is not checked, then the "Action Statu…