-
Returning a cell value if false
Hello all. Pretty new to Smartsheet here. I am trying to create a call that checks if one column, Trip, contains a value 1st, if it does NOT contain the value 1st, I want it to populate the contents of the corresponding cell in column Job Description. I keep running into errors attempting to nest the cell call =[Job…
-
Smartsheet Barcodes
Hello All, I have a sheet that has a specific barcode for each card. Ideally we would use the barcode functionality to scan an item, then select the option to bring you to the correct card. With it set up, when I go to test it, it only works occasionally. It will usually only bring me to the column that the card is in and…
-
Financials: projected, actuals and variance
Hi! Very new to smartsheet and looking for any preset reports for tracking 3-4 year project financials, specifically projected spend, actuals, and variance. Does smartsheet have this type of reporting? Thanks!
-
Combine Form Row information into Single Row data
Hello all. We are looking for a way to take rows entered via webform and then merge the information into a single row of data. To give you an example of what we are doing. We enter a building Number (currently Primary Column) and a unit number into the form. There are then unique items we are checking off in the form or…
-
Sorting
Hey Guys, I have created a sheet to help our construction company track our new leads. We have set it up to fill out a form that feeds information into the sheet. I have conditional formatting set up to identify each lead by their status. Periodically I will pull out dead leads and move them to a parent category allowing…
-
Function Help
How would I go about trying to create a formula that scan down a column finding and grouping the same "assigned to" and then grabing that specific %cost and totaling them up in another cell?
-
Bug: Text/Number Field changes itself to Date field for column.
This has been happening several times a day where a column I have designated for text input changes itself to a date field. I have data being input by form users to rows. They go to use the form and are presented with a date field where they are supposed to be inputing several sentences of text for their daily report. I go…
-
=DATEONLY VARIANCE COUNTING WEEKDENDS
Hi, Trying to use the =dateonly to get the variance between planned start and actual start, but it looks like the calculation is counting the weekend days when in only want it to count weekdays. Is this possible?
-
Update Request which create a new row
Looking to have an update request that would create a new row (much like a form would do). Here is the situation: - Row with Project Name, PMs, etc... A PMs has more than 1 project. I need to calculate the weekly hours for stats purposes. If I use a form, the PM must submit it and then click back on the email again and…
-
Changing actual start date - Predecessors delete
Hi, I wonder if someone can assist me. I am running schedules for construction projects with predecessors (Finish-Start relationships) set up. If myself/or another employee change the actual start date of a line item then it deletes the predecessors. I know that to avoid that from happening - You must either change the…