-
Hello - looking for help creating my sign in and out form.
I am fairly new (yet familiar with the possibilities available) in Smartsheet. I am in the process of creating a tracking form for my job to see anytime a device is in use and which employee is in possession of a shared device and what location they are working at that moment. I am collecting the employee's name and ID…
-
Link Sheets and pull multiple data
Dear Smartsheets family I am fairly sure this is a simple question but how can I link two forms and import multiple data information into the sheet by simply updating the unique form no. I had used a template and it stated a 'Portfolio Summery' that I cannot find. But non the less what is the process? Here are some screen…
-
Time
@Paul Newcome can you help. I have a formula that i had Gemini AI create that isn't working. for average time in mm:ss format. first can smart sheet display a result like this. 2nd if so, what is wrong with this formula? =TEXT(((SUM([Total Match Time]:[Total Match Time]) / Stats4) / 60), "[0]") & ":" &…
-
Frustrated
Hi All - I am new to Smartsheets and I'm attempting to teach myself as I go. I created a sheet for every department that also has a form attached with specific questions to be answered. Department managers will use the form link provided to input their information daily. I am struggling with how to get these metrics to…
-
Currency conversation using a table in a separate sheet
I would like to use collect/look-up to reference and convert amounts into USD. Columns on the sheet where the conversation needs to take place: Reimbursement Amount Currency 3-letter code If the 3 letter code is USD, copy the amount, if it is not USD, it needs to look up 3-letter code and times it by the conversation rate.…
-
How to highlight the values in the column which is greater than or less than the other column values
Suppose, the order quantity we have taken from the customer is 500, and the quantity we have placed an order with our supplier is 600 how to highlight this excess quantity?
-
Formula column disabled (greyed out)
HI, i'm new to spreadsheet, currently i'm on trial version (30days Trial) planning to buy after using it like one week, yesterday i've noticed i cannot convert text/number column into formula column it's greyed out. i've tried with different sheets different cell types it's still greyed out, please help out. Thanks Vinoth
-
COUNTIFS with DATE
Another day, another question to the Community...! I'm trying to get a count of all jobs starting in each month. My formula is giving me an #INVALID OPERATION error though. =COUNTIFS({Start Date} >= (DATE(2019, 1, 1)), {Start Date}, <=(DATE(2019, 1, 31))) What am I doing wrong?
-
Creating a Skill Grid for tracking
So, I am trying to create something similar to what I have in Excel in Smartsheet where it looks to match two things and if both are present it returns true, if not then false. The problem is it is referencing another sheet for both things. For instance, If Paul's name exists, and he has a date in Column 2, then true. Is…
-
Issue with If Statement
Not sure if it is possible, I have tried some basic if statements but not getting anywhere. Looking for some help please, trying to get an if statement to work in the Validation Status column, where if the due date is over 7 days the status column is populated with 'overdue', or if the due date is within 30 days then the…
