-
Feature request: company holiday management in Workspace
Hi there, I've seen some discussion on these boards about managing non-working time. It seems there's two out-of-the-box options, either to have each individual project manage their time or have a sysadmin do it at a global level. Some have suggested blocking time using a dedicated gannt chart. For larger companies across…
-
formula help
i need help with a formula please. my current formula looks like this.. =SUMIF(Stage:Stage, ???, [Job Value]:[Job Value]) i need an answer to the ??? please as it is a column that has a formula in it that relates to other fields and is a check box. if true then tick the check box. i am now wanting to sum the value of all…
-
NETDAYS is giving wrong result
The NETDAYS between 5-Aug-2018 and 9-Aug-2018 is coming as 36530. I don't know what's happening - can anybody help? =NETDAYS([Last Date Entered]4, Today4) The same formula in another sheet is working absolutely fine.
-
Production/task management with sales order taking
We are a small custom sign manufacturing company. Our clients can order any number of products at a time ranging from small items to custom furniture. All have a similar start to finish process with some customization along the way. We would like sales reps to be able to enter orders directly into a page with details on…
-
Company uses smart sheet in metro manila philippines
Hi is there any company here uses smartsheet in philippines specially in metro manila? may i know the company name thank you
-
Escalation Alerts or Notifications
Is it possible - whether in the Alerts/notifications or with a formula, to create an escalation based on inactivity of entries. Example: Operators enter the date when equipment is cleaned. this is required weekly. If 2 weeks are missed for entries (14 days), then I want a notification sent via email to their manager.…
-
index match formula not working
Hi, I am using the below index match formula which is not working. The MFG Rev 18 area range is a "contact list" column type, and the column used for the formula is a Text type. I assume the formula is not working due to the type, is there another way around this? =INDEX({Mfg Rev 18 area}, MATCH([Start Date]3, {start date…
-
Referencing another sheet using vlookup
Today's my first day using Smartsheet; I referenced another sheet for columns that I needed. Now rows that are not found in my specified range are auto populated with "#NO MATCH." I need guidance for making the "no match" blank. I tried an if statement but still having the same issue.
-
Automated Update Request
Quick Question - If I select 10 rows on a sheet today based on a column filtered on "Responsible Person" and set it to a weekly Monday send schedule... if a new row is added after the Update is sent today but before next Monday.... will next Monday's Update Request automatically send 11 rows because the new Row is attached…
-
Write Function that has 2 check boxes in it?
Hi everyone, I have had smartsheet for awhile and finally taking the time to learn/use it and am stuck. I have a custom apparel business and have made a sheet to keep track of all my orders and what the cost will be. I have columns for Quantity, Balance, No Fulfillment (check box), and Paid (check box). I have a working…