-
Adjusting trip start/end date based on certain members holidays
Hi everybody, I'm new to smartsheets and I'm not sure if there's a name for what I'm looking to do. I volunteer for a small afforestation project in my local area. And want to make planning our planting trips a bit easier, as all our members are college students with varying schedules and holidays planned. (I already have…
-
Help to create a formula that sums a column based on if values in two other colums are correct.
Hello, I have three columns that need to be in a formula. TIME, Y, Z I Want to SUM all the rows under the "TIME" column based on if the Y and Z columns have the specific dropdown value. This was my try but it did not work: =SUMIFS([Z]:[Z]; "Approved"; [Y]:[Y], "", Time:Time) Can anyone help? Kind Regards, Hugo Martinwall
-
I can't see/manage my Alerts & Actions
Hello, I have a problem concerning Alerts & Actions. When i first press it in the toolbar I can see that I have 10 Rules. But I can not go further to manage them. Anyone experienced the same problem?
-
Sending Email as an Attachment
I have an email scheduled to send a sheet as attachment. I've selected excel as the document type, however after I add the schedule, it changes back to PDF and when it sends it goes as PDF. How do you make it stay with excel as the document type?
-
Unable to save data to the database
I created a new workflow/smartsheet. Filter seems to be ok and update summary comes up with the correct amount of rows and information. But when I select Save Workflow it complains with !An error occurred, Unable to save data to the database. Anyone else having this problem?
-
SUMIFS Issue
Hi, I have a client master list on my Smartsheet and I want to get the total monthly fee of those clients that have an "Active" status Both the monthly fee and status are in my Smartsheet and when I tried using =SUMIFS(MONTHLYFEE:MONTHLYFEE,STATUS:STATUS,”Active”) I got an #UNPARSEABLE error. Please help. Thanks!
-
SUMIF vs. SUMIFS
I am looking to add the total hotel night stays from multiple labels in a single criteria column. This is my formula, but it results in "0" which is incorrect: =SUMIFS(NIGHTS10:NIGHTS38, AFFILIATION10:AFFILIATION38, "Researcher", AFFILIATION10:AFFILIATION38, "RAN", AFFILIATION10:AFFILIATION38, "ECD awardee") NIGHTS:NIGHTS…
-
Project Cost Calculator Smartsheet
I am looking for a template in smartsheet that I can use to build costs for projects and training courses we conduct. I noticed that on the smartsheet website advertisement it says that smartsheet has the solution. My goal is to program some of our costs to do business with certain rates and then send forms to the Program…
-
Can Barcode Scan return Sheet Data and Auto Complete Form?
Hi! Help!! I'm working on a Sheet to help with our Kanban System. As an employee takes a part from the Kanban Bin, we would them like to scan a QR code of the part taken via a form and the barcode reader on his smart phone, we have set up a test sheet using a lookup table of all parts (on a separate sheet "inventory") then…
-
Only print field in form when value is not zero
I have multiple columns in my smartsheet that may or may not get filled in ($), depending on the specifics of the permit. I do not want the fields that remain $0 to print or show up on form. Only fields that get filled in with a dollar amount need to show up on printed form. Can't seem to figure this out.
