Discussion List
Adding IF Contain to a V-lookup Formula
Hello, I can't get a formula to work... I have a VLOOKUP formula that is working correctly in this sheet under "Payroll/Benefits need" column, pulling from a reference sheet which is HR PROJECTS Range 2. =VLOOKUP([Project ID#]@row, {HR PROJECTS Range 2}, 13, false) What I need to add to this formula is... IF the cell…
Can we get the date format to MM/DD/YYYY form?
Let me know if this can be done by changing the regional preference. If so, please tell the regional name to go with
Where do I find my SS account number?
Hi Can someone tell me where I can find my account number on the SS platform? I cant seem to find mine. Thanks
Conditionally send reports
Problem: Sometimes my reports have no items as all the actions are closed in the underlying sheet. It is then irritating for my email recipients to receive a blank report. Ideal state: To have two options: Dont send the report if blank or send an automated email still on the recurring schedule stating a custom message…
#REF on formulas and functions
I'm currently getting #REF on my formulas that are cross referenced between sheets. all the formulas are still there and have not changed. the data is all still there. is there an issue with Smartsheet not calculation cross references? thanks Scott
Apply part of invoice to different object codes
Hello, I am trying to write a formula to give me the amount of an invoice I need to apply to 2 different object codes. GL code 6022 needs to be used for payments from $100,000-$125,000 and the other GL code 6021 is used for everything else. I have a current invoice column and a historical invoice column. So for example:…
how can I display multiple spaces? " "+" "+" ", Char(32) + Char(320 etc...?
I am trying to create concatenated text with multiple continuous "spaces" so I can map that in PDF in one go, like below. ID: XXXXXXXX1 Name: First Last ...... ID: XXXXXXXX2 Name: First Last ...... With the formula below, " " will endup with single space as well as Char(32)+Char(32). "ID: "+[ID]@row + " "+"Name: " +…
Saving, Export, or Archive Notifications
Is there a way to save, export or archive Notifications?
Tracking reachouts
My sales team is currently having issues to track our total number of reachouts. We track each reachout by updating a date column when the reachout is completed. A filter is then used to track the reachouts in the last 30 days. However, I recently noticed that if the same row is contacted more than once in the last 30 days…
Chart missing client name as legends
Hello I am having issues charting 3 metrics in a scatter chart for our dashboard. Customer Name - Units required - Year commencing. My units [MV] are vertical, [COD Start] is horizontal BUT my customer name [Primary Row] is not showing as legends. The plotting is correct and this is how i want to vizualise the data. Any…