-
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…
-
Search and Replace, Conditional Formatting
I have multiple columns with a variety of drop-downs on many sheets. Conditional formatting is set to many of the columns based on the drop down selection, sometimes up to 40 statements. The problem I'm faced with is if I change one of the drop down selections (abbreviate a selection for example) that is currently being…
