-
VLOOKUP with IF and IFERROR Formula
I need to figure out the VLOOKUP formula within the Barrier Management Survey Status Sheet to where IF the Services Completed is “Door Program” (within the Shared Services Program Survey sheet), and the Facility Name matches, to then pull in Survey Status “Complete”, otherwise (IFERROR) "N/A". This is the new formula I…
-
Personal consultant
Hello Everybody, I need assistance for building a solution for my company with smartsheet, I'd like to know if I can have support by a freelance expert or a partner. I'm in Italy, so it would be great if we could speak italian, but in english is also good. You can write me at f.cesaroni@immoveo.it Tank you very much
-
Automation Suddenly Not Working
I have an "Request Approval" workflow I created back in August 2019 that was working perfectly fine until late last week. I can't find any reason for it. Nothing was changed on our end. Is anyone else having automation problems??
-
Referencing Values While Using Workflows and other grievances
There is some serious disconnect between Workflows and Formulas/Functions. I use Smartsheet mostly for task management on a small software development team. When we submit a code change it must go through multiple steps in this case: Development, Testing, Code Merge, and a few other tasks. I want to create a form that…
-
contacts
I have entered my smartsheet contacts manually including their email and name. Afterwards when using my contacts to send out update requests, only the email for the person is displayed for about 1/2 my list, the other 1/2 has both email and name. This display changes at times. I have edited their contacts and added the…
-
Formula to return 'TBA' if cell contains text 'TBA'
Hi, I'm currently using this formula which works: =IF([\[H\] Variance (%)]@row < 0, "Under Budget", IF([\[H\] Variance (%)]@row = 0, "On Budget", IF(AND([\[H\] Variance (%)]@row > 0, [\[H\] Variance (%)]@row < 0.15), "Moderate Budget Overrun", IF([\[H\] Variance (%)]@row > 0.15, "Significant Budget Overrun")))) However, I…
-
Newbie Question: Want to Count "Product Name" but only if its date is in the future
Hello! I am very new to Smartsheets and I am trying to get the best use out of it. But, I am little stumped. I have a COUNTIF formula to count how many times a product name is mentioned in the sheet and then I used conditional formatting to highlight it if there is more than one time the product is mentioned.…
-
Back up not complete
I requested a back up of my smart sheet on the 24th. It is still pending. Who do I contact to get that back up. Smart sheets won't let me attempt another back up with that one still pending.
-
Is possible change the ADM e-mail?
I have a problem and I would like to change the ADM/Owner e-mail. Is that possible? If yes how can I do it? Best regards
-
Indent using a non-US keyboard
I'm using a keyboard where '[' and ']' are found using "Alt GR + 8", "Alt Gr + 9". How do I indent using the keyboard? "Ctrl + Alt Gr + 9" does not work. I have also tried using Ctrl + M as proposed in another thread. Thanks Lars Bo Wassini