-
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!
-
Form stopped working
A form I have been using for weeks has stopped working, I've not changed anything on the form and the sheet. When I choose to send my responses I get an email with the data I entered but the sheet doesn't update. the sheet is empty at the moment so they aren't going to the top or the bottom and the count on the form for…
-
If/Then formula with two options based on a date?
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 an "Archive Date" for each row. However, I now need to adjust the formula to be either 8 days or 30 days, depending on the…
-
INDEX/MATCH returning #NO MATCH error but only for ONE cell
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 inside an IF statement because the Done column checks if there's a submission for the email in the first place--I only want the…
-
Rows being inputted randomly?
HI, I have a smartsheet form that connects to an intake tracker. However, when the form is submitted it moves the form data to random rows and now row 1. Does anyone know why smartsheet does this or what the solution might be? I need this solved quickly because I am creating this intake process to be handed off to another…
