-
Half day vacations
Hello, I built a form for my department to request and track their vacation days. The standard data includes date of request, start date and end date, as well as, adjustment days to exclude holidays from their remaining allocated vacation days. However, some are asking for half days, I put a checkbox in the formula but how…
-
A3 Report
Hello Team, is it possible to create a A3 Project Report in Smartsheet according to the template I attached? I already tried to create it, but it did not work for me. Purpose of this sheet is to have an A3 Report for some projects. Looking forwards to your feedback. Best regards, Chris
-
Hello - trying to not display zeros in a cell based on column 1 and 2
=IF(AND(ISBLANK([Start Date]@row), ISBLANK([Due Date]@row)), "", VALUE([Impact Score]@row) * VALUE([Probability Score]@row)) Receiving unparsable. Any help would be appreciated.
-
Change first day of week to MONDAY, instead of SUNDAY
Hello! I found that in 2015 there was a request to give users option when the week should begin. In some countries it starts on Sunday, in some on Monday or Saturday. However the dropdown menu is still the same after 7 years. Or is there any option that I've missed? Best regards!
-
Trimming all spaces
Hi, I am trying to apply a formula so that when meta data is input it is automatically trimmed to have zero spaces, which I know how to do in excel but does not seem to work in smartsheet. So, I have a column where we input license plates, but people always add spaces making sorting the column a little annoying as…
-
Bulk Updates
Hi, I have multiple sheets that is getting data with formulas from one specific sheet that gets updated 3 times a week. I'm calling this sheet as the bulk update sheet. Since SmartSheet doesn't allow to import from excel on that particular sheet, let's say override the existing, all the time I need to copy paste all the…
-
Nest If/Or with Contains
So with multiple drop downs I want the HC Froup to result in either one of three returns: backfill, backfill repuposed, or new. I am getting an uparseble error. Following is a snapshot of the attempt
-
I have one column Miles and a second column Billable miles.
MILES BILLABLE MILES (RESULTS) IF miles is > 1 miles -500, if miles < 500 "N/A"
-
Multiple Criterion with Cross Sheets
Hello I am stumped. I have tried several different combinations to my formulas trying to get them to function. I get an #UNPARSEABLE error most of the time. I have tried this formula =COUNTIFS({Complete Claim Status}, Status@row, {Vendor Name}, [Vendor Name]@row) Complete Claim Status is the range on my cross sheet |…
-
Using RIGHT/LEFT or FIND/REPLACE?
I thought that by using RIGHT and returning the values after ", " that it would fix the issue I'm having but depending on the difference in timestamps, I may get 7 or 8 characters so this formula doesn't work out for me. Would using FIND/REPLACE work, such as finding ", " within the column and replacing that with just ""…