-
% 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?
-
Transferring Workspaces
I've had my intern create 168 workspaces, with each workspace containing approximately 20-50 sheets each, organized into various folders under each workspace. Each workspace also has 3-4 dashboards pulling together this information... With my intern leaving at the end of next week, what is the easiest way to bulk transfer…
