-
Card View Restrictions
I have a user with Admin privileges, who is unable to see the 'View by Assigned to' dropdown from Card view. They also do not have the Card View Settings tool (gear) near the upper right corner, to be able to turn this on. From my account, I can do all of this on the same sheet, but he can not. What am I missing for him to…
-
% Rool-Upon another sheet
I have created a construction schedule where i have many lines of of tasks that apply in a mixed format to different subcontractors. Each task has it own % value. I have created another sheet where I have listed the Subcontractors and am trying to roll up the %of every line (associated with a specific subcontractor into a…
-
DATA BASES
MY NAME IS RAFAEL AND I START MY SMARTSHEET, AM GOING WELL , ONLY NEED SOLVE ONE QUESTION. HOW TO USE A DATA BASE, REALLY 7, ARE FOR THE IMPORTANT DATA AND FORMS REGARDING AND USEFUL THE EACH TASK. LIKE PRODUCTION ORDER, PURCHASE ORDER, INVOICE , QUOTITATIONS, CLIENTS AND TEAMMATES IN THIS OFFICE OR CHANGED TO THE OTHER…
-
Conditional Formatting on Date is not taking into account local account timezone settings
Conditional formatting using a date, is not taking into account the local account regional settings/timezone and appears to be using a default time zone. As conditions like change the color of a cell if the date in that cell = Today, is still highlighting the cell on the next day. My Time zone is set to Australia/NSW…
-
Date range formula
I am trying to write a date range formula with an IF AND statement (I think). I need to check a box if [Previous date] is in a specific date range.
-
I can't see/manage my Alerts & Actions
Hello, I have a problem concerning Alerts & Actions. When i first press it in the toolbar I can see that I have 10 Rules. But I can not go further to manage them. Anyone experienced the same problem?
-
Sending Email as an Attachment
I have an email scheduled to send a sheet as attachment. I've selected excel as the document type, however after I add the schedule, it changes back to PDF and when it sends it goes as PDF. How do you make it stay with excel as the document type?
-
Commission tracking
Good morning Smart Sheet community. I have been tasked to create a commission tracking smart sheet for our sales team. If you have a pre-fab sheet(s), and willing to share, I would be forever grateful. Otherwise, here was my thoughts on said sheet. First sheet would be for the actual sales. This would have a form available…
-
Children function won't work past a certain rownumber
Hi, I am trying to use a sumif >>> =SUMIF(CHILDREN([Sales Stage]30); Status15; CHILDREN([Quotation budget]30)). However for some reason this function wont work passed row 40. Please help. Jesse
-
What actions affect only my Smartsheet? What actions affect all shared users?
If I add a filter to a shared sheet does it add the filter for everyone else too? Also if I highlight changes from last hour, does it highlight it for other users too?