-
formulas within the Content Calendar
I am using a content calendar template. All the formulas were already a part of the standard content calendar Smartsheet. We noticed that since the new year (after January 2020), all the dates automatically shifted. The December 2019 parent row changed to December 2020. Please advise what I need to do to fix this calendar.…
-
Archiving a Child row with it's parent row.
Hello everyone! I want to set up a workflow where I move a row when it check off as archived. But that row is a child of a parent row. How can I move both the child and parent row from my sheet, but also not actually remove the parent row from the master sheet? Thank you!
-
Can I return the hard value of the result of a formula based on another formula being populated?
I have formulas used to create target finish dates. What I would like is to have the target finish date show the date based on the formula when the Actual finish date column is blank. But when the actual finish date is populated I would like the formula to be removed and the date that the formula produced be populated...so…
-
Placeholders | Still batching Emails
Hi team, I'm using Placeholders in a workflow to generate individual emails for an update request. Although the same individual received the update, they will forward as needed, so I need to ensure each update request for the day doesn't 'batch'. I've done a small test and had no issues, but when i moved into the live…
-
Help with INDEX MATCH with duplicate unique identifiers
Hi Community, I am working with an INDEX MATCH formula to return content from another sheet; however, for each unique value, there are 4 duplicates. For example, an associate completed 4 learning events all attached to the same cohort name. Records are displayed as: Associate 123456, Cohort 1, Learning Event 1 Associate…
-
Embedded links in Plans
I have created a template suite and my project plan has links to other docs within the suite. When "Create as New",the embedded links only link back to the original template suite and not the new files. Is therre a way to make the links follow the newly created folder?
-
#NOMATCH multiple function
Hello, I actually have some #NOMATCH problem, that I can't explain because it work different cells of my sheet that have same parameters. My formula is : =IF(ISBOOLEAN(VLOOKUP([N° CONTAINER]1; {LDS Container Dashboard plage 2}; 21)) = 1; 1; 0) When I check column where I take datas, it should be checked as well If someone…
-
Sort function
Hi, Can anyone help me please - how do you disable/enable sort function in sheets? We have some where you can sort with editor access, and some which you cannot sort with the same access. Many Thanks
-
I need help calculating days btw 2 tasks
I need help basically calculating lead time for a portion of a project. For example to Calculate Planned days I need a formula that would subtract the date the Samples where approved from the date the Mass Production is scheduled for delivery. So the formula would calculate something like this: MP Receival - Golden Sample…
-
Nesting IF, AND, etc. syntax
I am trying to get a status to report as flagged in certain situations and not others. I need it to be specific, because I have alerts for when the status is flagged and I don't want it to happen when it isn't necessary. Right now I have: IF(ISBLANK([Last Maintenance Check]@row), 1, IF(ISBLANK([Next Maintenance…
