-
Update Request single use link
Does anyone know if there is a way to allow a recipient of a "Send update request" to use the same link more htan once to update a particular row? An installation within my organization is a single day event but can span the entire day. I may need multiple check-ins from my field tech. Today, I send an update request to my…
-
CALENDAR WITH FORM
I work with the control of scheduling of some cars. The employes need to make a scheduling reserving these cars to use. I would like to know if is possible i create a form where they make a reservation of the car seeing which day is available or not to do the reservation, to do not overlap other reservation made before…
-
shift project dates globally
I've created a schedule but now need to move the dates back globally by about 2 months. In another scheduler I use you can simply globally adjust dates + or - as you need - very convenient when the start date isn't nailed down yet. I don't have all the fancy dependencies set up - I haven't grown that far with setting it…
-
How to use a range of numbers in a formula
Hi SmartUsers, I have a formula to show bars according to the completion % of a cell. The formula is: =IF(Completed?9 = 1, "Full", IF([% Complete]9 = 0.25, "Quarter", IF([% Complete]9 = 0.5, "Half", IF([% Complete]9 = 0.75, "Three Quarter", IF([% Complete]9 = 1, "Full", "Empty"))))) It'll show 1 bar if a task is 25%, 2…
-
smartsheet realtime co-authoring
Can we work at the same time on different records.
-
Formula to calculate count of checkboxes in multiple columns and child rows
Hi Everyone, I'm trying to write a formula that adds up the number of unchecked child rows in the Complete column and then subtracts the number of checked rows from the Non Applicable column. The result should be a number of tasks left to be completed from within that parent and child section. I've tried a bunch of…
-
Need to build formula that includes a drop down menu as an option, need advice
I am trying to build a formula that includes a drop down menu as an option. This is what I am trying to do ... =IF([COLUMN1] = "Campus name", then [BUILDING NAME], otherwise "Please select your campus before selecting the building name") * COLUMN1 would be a drop down menu with campus names * BUILDING NAME would be a drop…
-
General Plea for Openness
I would like to ask community members to add some details into thier profiles so that we all can get a better understanding of who you are, what industry you work in etc. The comunity is about sharing, helping and working together and this is much nicer when you know a little about who is asking for the help or guidence.…
-
Still Looking for an IF function that does nothing to the cell if False
I asked about this back in April and got a few suggestions but nothing that really worked for me so I'll try again. I keep track of the hours charged to around 35 projects by people in a dozen functional areas on a weekly basis and send the monthly total into our finance team for their revenue recognition process. I use…
-
Trying to create a fancy email with status reports from multiple teams
I'm trying to go a bit above and beyond, using SmartSheets to track the status of multiple projects across multiple teams. Currently, we have links to multiple sheets (one for each team) and they manually go in, add a new column per week, and fill it in with a bunch of text explaining the status of that project this week.…