-
Can someone assist with looking at children rows vs selecting exact cells?
Hello! Each time I change the sorting of this sheet, my formulas are changed. The formula is technically correct, the issue is that I am referencing exact cells, so when sorting it throws it off. =SUMIF([Open By Year]38:[Open By Year]43, @cell < TODAY(), [Total Units Signed For]38:[Total Units Signed For]43) - [# Open]@row…
-
Within a SUMIFS formular, I'm trying to add on to a count if a contact appears in a multi-contact or
-
How can I add a number of days to a date column in the same sheet?
Hi! I currently have a column that is supposed to add 14 days to another date column in the same sheet. The formula I'm using is: =["Date Column"] + 14 However, what I keep getting is "Apr 21, 2020 3:10 PM14". Both columns are date columns. Thanks so much in advance!
-
Many columns on sheet - not all appear as options in a report?
Happy faux Friday! I'm working with a very large (about 30 columns) data sheet in Smartsheet. I'd envisioned it as the one source of truth to feed multiple reports. The problem is the latest report I'm trying to build, the 5 columns that I need to appear and provide data, are not showing up in the columns from which I can…
-
I want to count the number of times a contact appears in a column, how do I do that?
So, I started with =COUNTIF(Name:Name), FIND("John Smith", @cell) > 0) this produced #unparseable. My ultimate goal is to have a dashboard that will display a pie chart with total number of leads per person. Thanks for any help!
-
Sheet/Folder Lock
Hi all, I keep running into an issue where I have core sheets in some workflows/dashboards that users keep deleting and I have to go back an restore it. I would love to have the ability as an Admin to lock a whole sheet to prevent it from being deleted. Ideally, this sheet would still be editable in this use case.
-
Column Name Change Doesn't Break Report
I could be dreaming but didn't Smartsheet fix the issue where changing a column name breaks reports? Did this get released and then rolled back or am I imagining things?
-
Am I missing something - adding formulas in sheet summary?
When I attempt to set a formula in sheet summary the wizard give one option of ‘Refernece another sheet’ and not the sheet you are in. When I click click on the column header in the sheet (i'm in) to set the range this is what I get this: This is different to adding a formula to a cell in a (metrics) sheet where you can…
-
The link out arrows have disappeared?!
I have two SmartSheets in use. One for my engineering team, and one for my construction team. I have hundreds of cells linking in and out of both sheets to one another. For some reason the cells which are sending the data (Linked Out) are not showing the little black/grey arrow within the cell, but the cells which are…
-
PTO/Sick Accrual Calculations
I started a new job and a bit overwhelmed. I am new to Smartsheet and a basic user with Excel. I need help with PTO/Sick policy calculations within Smartsheet. I do not know where to begin. Any help is appreciated!
