Our office is new to the SmartSheet community. I am having some trouble creating a formula for a sheet. I have the following columns:
I have a smartsheet to track staff working hours and how much time they are up/down based on their contracted hours. I want to be able to get the data in the Minutes Credit/Debit column for the last row (circled in red). The sheet will be added to using a form.
I want to be able to pull the
I'm trying to use the WEEKNUMBER() formula while calling a cell with a date in the format 07/17/19 and I keep getting an INVALID DATA TYPE error and I cannot figure out why.
This is the formula in the cell:
=WEEKNUMBER([Install Start Date]1)
The [Install Start Date]1 displays 08/08/19 but is
Wanted to check if there is a mechanism wherein smartsheet can store the information collected via different forms at different points in time in a single row ?
Providing an example below for more clarity -
Lets say we break the client engagement (an enquiry -- lead generation -- service
I am looking for a seemingly easy solution which I can't find. While the workflow automation helps in many ways, the "actions" available seem to be greatly lacking. For example in google sheets + scripts + triggers, I can have a cell update based on a formula from a time driven
help me please I want to see in our project through a filter in which I specify: 1) If the status is not fulfilled 2) Deadline date in the past This is all I can do, but through the filter I need 3 points 3) All tasks that have a predecessor with a task number (which is not completed and overdue by
Not sure if this is supposed to happen, but since i was not expecting it at all, i found it extremely frustrating.
So i have a spreadsheet that is using several index/match formulas on different columns to pull information from other spreadsheets.
But today, one of the Admins on another
I know Smartsheet is "working" on time stamps, but I need a little help. I am trying to calculate 2 different time scenarios. First is from the time a work order is opened to the time its is dispatched. Second is the time from the open date to completed date.
You will see on my sheet, the "open