-
Column Highlight
is there the ability to colour in a column not a row to show for example UK bank holidays or staff holidays etc.. to show in a very quick visual way any clashes that might be avoided.
-
404 Error - Event data - Smartsheet API
Hi, I am attempting to get event data from the smartsheet api. First, I tried the new api documentation method which suggests a request to the event api url. Traditionally, you don't pass both a parameters variable AND parameters in the url which is being suggested in the documentation. I tried a few different ways and…
-
Formula: if checkbox is checked then add or subtract
Hi everyone, I would like to have a sheet that tells me how many goods we have left in our warehouse. The idea is that employees report via a dashboard whether they are taking something out of stock or returning something. If one checks the column "IN" or "OUT" they also have to add the amount. That amount should be…
-
Card View for Reports
Any idea when or if we will see Card View on Reports in the near future? If not, I'd like to add my vote for this feature as soon as possible; it would be very useful to our workflow. Thanks.
-
Help with SUMIF Formula
Hey Community, I need some assistance with a SUMIF formula. I am trying to say, Multiply Column 1 by Column 2 IF Column 1 is greater than 1, if not, leave blank. I have tried several different ways but all keep coming back #UNPARSEABLE. Would appreciate some help with this. Thank you in advance!
-
Smartsheet count function
I'm using the count function to count how many times a initial appears in a line and its working great except it won't count a line that has multiple initials in it. Does anyone know how to get it to count that line?
-
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…
