-
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…
-
Sharing a Folder in a workspace
How can I share a folder with specific people in a workspace while limiting them from seeing other folders in the same workspace? ...It's been over two years since this feature was requested. https://community.smartsheet.com/discussion/sharing-folder-workspace#comment-form
-
=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?
-
Keeping persistent dates for status changes
Building a kanban board with typical IT cycle states: Ready, Dev, Test, Deploy, Done. I'd like to track cycle times and throughput. I've created (locked) columns to capture a status change for each of the cycle states; e.g. Dev Start and formula "=IF(Status@row = "Dev", TODAY())". That works to capture the date that a task…
-
Outgoing Links Not Working Since Update
Hello, I have been experiencing issues with my outgoing links not working since the last update. If I change the data in the outgoing link, it points to the correct cell, but the data is incorrect. The only way I can fix it is to delete the links and then add them again. I do not have the time to do this for all of my…
-
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…
-
VLOOKUP from another SS Sheet
I am sure this is a simple formula, but I still find the Learning Pages quite vague an complicated for the person unfamiliar with formulas. I have a sheet for Change Orders (Called "Change Orders"). I have a second sheet with Job Numbers (Auto Numbered) in the first column and Project Names in the second Column. This sheet…
-
Report with multiple tasks as ("what") conditions
How do I create a report with multiple tasks (in my primary column) as conditions? E.g. I wanted to display sheets in a report where Task 3 = Yes AND Task 5 = No.