-
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…
-
Linking the text in a cell to a document
If I have a PO # that occurs in multiple cells. Is there a way to link the PO# text to the actual document? I don't want to link the cell to another sheet. I want to link the PO# text to the actual PO document. So a team member can simply click on the link to view the PO.
-
Mobile app doesn't show dashboard graphs
I can't view any of the graph widgets on the mobile app. Is this a known issue or are my settings wrong?
-
Formula Assistance
I am attempting to automate my project list by scoring each project based on calculations in another sheet. I would like to create a "Project Score" based on drop-downs in my project sheet. Sum=Complexity*weight + cost*weight + impact*weight +resources*weight + value*weight. The values of each category and weight are in…
-
count values where two columns match
i am trying to count the number of matching pairs of values in two columns. eg: Column A Column B 1910 760 1910 810 1910 810 1990 760 1990 760 the outcome of the above that i am looking for is as follows 1910 x 760 = 1 1910 x 810 = 2 1990 x 760 = 2 can someone please help me with a formula that will give me these count…
