-
Smartsheet loading blank page
Is anyone else getting a blank page when they log into Smartsheet? I get the blue bar at the top but nothing else.
-
Pivot tables
I am trying to transfer pivot tables to another owner but I receive a message "Error! user not found. The new user needs to be shared to the source/report as an Admin in Smartsheet" and the action is not complete. Can you please advise? not sure how I can grant the admin title on the pivots.
-
Reports
Hi, Recently I create an report file, where I want him to show certain columns. I choose for "Where" condition the location from where i want him to extract the info. But if i will create another new sheet in that folder, even the entire folder is choosen for report, he dosn/t know to automatic include that new sheet in my…
-
Contributors and removing access
Hi Within our company we have a number of 'free' users, in the event of said person leaving is there any easy way of removing their access or is a a case of going into each smartsheet and removing individually? Rs Abbie
-
Dependency from a cell on another sheet
Hello, I run my manufacturing jobs on Smartsheet. I have one sheet with multiple projects on it, Parent row per project and tasks indented I have a few milestone dates in each project for equipment arriving (this date is linked from a shipment tracker) which other task tasks within the project are dependent on before the…
-
Nesting Parent(Parent())? Is that a thing?
I had a super long post but I'm finding that the people who tend to respond are people who want to be hired as consultants. I'm not really interested in that, so I figured out my own issues the best way I could. :) I've got myself to this point =SUMIFS({Resources_Required Data}, {Group_Name}, {Group 3}, {Weather Data},…
-
Number less than zero is shown as a zero
Hello again community, I am hoping someone can help me understand the right way to write this formula for what I am trying to achieve. I am wanting to subtract one cell from another which in some cases provides a negative number. I would like the formula to pick up on this negative number and output a 0 in place of the…
-
COUNTIF problem with OR / " INVALID DATA TYPE "
Hi all , Can you tell me what's wrong with this formula : COUNTIFS({Catégorie_courrier}; ="Permis"; OR({COURRIER_Réponse}; ="Oui"; {Traitement_demande}; ="Oui")) It returns the error message : " INVALID DATA TYPE " . As {Catégorie_courrier} , {COURRIER_Réponse} and {Traitement_demande} are 3 ranges each corresponding to a…
-
Cell Value Minus -? Is this possible in Smartsheet
I am working on a pretty massive data sheet and I have 4 years that are broken down by Months and then by Days of the Week. =SUMIFS({Resources_Required Data}, {Group_Name}, $[Primary Column]$197, {Weather Data}, $[Primary Column]$214, {Day of Week Data}, $[Primary Column]215, {ADD_TIMESTAMP Data}, >=DATE(2016, 1, 1),…
-
Product Suggestion - Admin Issues
This popped into my head as we have one of our licensed users who just refuses to share anything with any of us. What happens if they create a lot of important sheets that contain data and part ways with the company, how do we access this? The Super Admin should automatically have the ability to have access or a backup to…
